Grouping Numbered Data into Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a table with a number field with values from 0 to 9999. I want to have a make table query that will change the individual value of that number into the group that it falls into. For example instead of having the number 524, I would like it to display the text string "501 - 1000." I want to split the values into 4 groups/categories. Thanks,
Alex
 
Here's a possible way to handle this challenge:

Create a new table....call it NumberRange or whatever you
prefer. Create 2 fields in this table...one called Upper
and one called Lower. Make sure the data type is set
to 'Long' for both fields. Populate the table with your
desired ranges. Now create a new query and select your
original table and your new NumberRange table. The sql
should look something like:

SELECT YourTable.YourNumber, [Upper] & " - " & [Lower] AS
Expr1
FROM YourTable, NumberRange
WHERE (((YourTable.YourNumber) Between [NumberRange].
[upper] And [NumberRange].[lower]));

-----Original Message-----
Hi,
I have a table with a number field with values from 0 to
Click to expand...
9999. I want to have a make table query that will change
the individual value of that number into the group that it
falls into. For example instead of having the number 524,
I would like it to display the text string "501 - 1000."
I want to split the values into 4 groups/categories.
Thanks,
 
Back
Top