Posted on 2014-04-11
I have an access table with 3,752,801 rows. There are 5 columns and I have set the first 4 of them up as combined primary keys, had to do this because of the duplicates error. Example:
Nursing Home Worksheet Line Number Column Words
1004282 A00000 100 0 0100CAP REL COSTS-BLDGS
1004282 A00000 200 0 0200CAP REL COSTS-MOVABLE
1004282 B10000 100 400 ADMINIS
1004282 S200001 200 200 FL
If the bottom row, as I have showed in the example, does not say KY in the words column I want to delete all information for the 1004282 Nursing home. I have researched and played with the queries until I am blue in the face. Please tell me there is a very simple way to do this.