grouping records

[ahajee]

I need to create a new field that takes records from another field and groups them together.

for example. State
TX
AZ
MD
DC
NJ

i want to create a field named "northeast' and i want it to group 'MD', 'DC', 'NJ' together.

 

[Joe4]

So what exactly is your question?

As you implied, simply create a new field named "Region", or something to that effect, and fill in the appropriate region for each state.

Then in queries, you can sort by this field to "group" these on queries. On reports, you can actually make use of the Grouping option.