Thread: classify
View Single Post
  #1  
Old December 7th, 2009, 02:17 AM posted to microsoft.public.access.queries
Miriam
external usenet poster
 
Posts: 11
Default classify

After calculating an average, I need to classify each member as 1, 2, 3, ...
10. 1 = an average of 3.99 or lower, 2 = an average of 4.0 - 4.75, etc.

How can I set a field to a particular classification, or "handicap", based
on given ranges? Does this require coding or VBA, or can it be done through
a query?

thanks!