Re: classify
- From: KARL DEWEY <KARLDEWEY@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 8 Dec 2009 10:58:01 -0800
look up that table and return the range number.Create a table that defines the range, and you can then create a query to
It takes a bit of effort to get this kind of query working.
Translation table --
Low_Avg High_Avg Classification
0 3.99 1
4.0 4.75 2
4.76 8.99 3
I find it easy, something like this --
SELECT [YourFields], [Classification]
FROM YourTable, Translation
WHERE Average Between Low_Avg AND High_Avg;
--
Build a little, test a little.
"Allen Browne" wrote:
Your ranges don't look like a simple, linear scale, so it can't be done with.
a simple expression. Create a table that defines the range, and you can then
create a query to look up that table and return the range number.
It takes a bit of effort to get this kind of query working. Tom Ellision
explains how in this article:
Lookup in a range of values in a query
at:
http://allenbrowne.com/ser-58.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Miriam" <Miriam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B34B564E-6955-41EB-8863-EB38810773DE@xxxxxxxxxxxxxxxx
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?
.
- Follow-Ups:
- Re: classify
- From: vanderghast
- Re: classify
- References:
- classify
- From: Miriam
- Re: classify
- From: Allen Browne
- classify
- Prev by Date: Re: Boolean expressions in the where statement
- Next by Date: Re: Change Form/Report Query Based on User Selection
- Previous by thread: Re: classify
- Next by thread: Re: classify
- Index(es):
Relevant Pages
|
