Lifeseeker
Registered User.
- Local time
- Today, 13:57
- Joined
- Mar 18, 2011
- Messages
- 273
Hello,
I am exploring a concept.....
All records are in Excel format now. An example would be...
FI #(pk) sign_status
P122423 BBA signed on 2010/07/15
BBA signed on 2008/04/15
Now once above record is loaded into Access, is it possible to do a query to pull all records that contain "signed" in the sign_status column?
I wonder if I have to just separate those multiple columns into individual column linking back to PK so here it is:
P122423 BBA signed on 2010/07/15
P122423 BBA signed on 2008/04/15
I think this way will create duplicate PKs in the table as shown above. I would like to keep the PKs unique as more information about the PK will get imported into Access down the road.
any ideas on the query?
thanks
I am exploring a concept.....
All records are in Excel format now. An example would be...
FI #(pk) sign_status
P122423 BBA signed on 2010/07/15
BBA signed on 2008/04/15
Now once above record is loaded into Access, is it possible to do a query to pull all records that contain "signed" in the sign_status column?
I wonder if I have to just separate those multiple columns into individual column linking back to PK so here it is:
P122423 BBA signed on 2010/07/15
P122423 BBA signed on 2008/04/15
I think this way will create duplicate PKs in the table as shown above. I would like to keep the PKs unique as more information about the PK will get imported into Access down the road.
any ideas on the query?
thanks