Categorize records

[lizzywu]

Hi there,



I have to ask some questions about tables, which might be easy to you, but I'm newbie in Access and try to learn it.

In my table, a column contains different fac# like fac-0086, fac-6200, and fac-0049 (they can be duplicated). These fac# can be categorized into 4 groups. Each week I need to load a list of records from spreadsheets into my cumulative table. The original spreadsheets have fac# but no group code. If I want to group the records by their fac#, how should I deal with it?

Any help or suggestion is greatly appreciated.

Best,

Lizzy

[hertfordkc]

Do you need another table relating the fac# to the group? If not, I don't have enough information.

[lizzywu]

Hi Hertfordkc,

Whatever way can work, that's fine. I can do another table relating the fac# to the group. Then what should I do?

Thank you very much.

[hertfordkc]

if you have a table relating fac# and group, then you can run a query using the two tables which will group the data. With that data, you could also do an append to your cumulative table, assuming that duplicate records won't be created. If there is a chance of that, then you will have to develop a strategy for preventing that or eliminating the duplicates.

[orange]

Do some research on Normalization. You need to get your tables structured to meet your requirements.