I have a HUGE access file with names, addresses and types of business in the spreadsheet.
Here is the trouble (if I can explain it) The name address and other info is in row 1..........the type of business is in row 2 (corresponding to the name and address in row 1) I want to sort by state and business type.....for example I want all "A" type businesses in Indiana. Since they name and address are in the same row I can do that fine. But I have no idea what type of business it is because it sorts those alphabetically by themselves.
The only thing that the 2 rows have in common is that there is the same number in field 1 for the name address AND business type. Here is an example of what I'm talking about:
0000000023 John's Diner Anytown, CA USA 555-555-5555
0000000023 restaurant
How do I filter or sort these so I can sort and get the state and business type in the same place.
I'm very new to access so if somebody could help me and tell me how to filter or sort I would be VERY appreciative!!!