contains() query

[Lifeseeker]

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

 

[DCrake]

Is the information in seperate columns in Excel to start with? if not, try using the Text to Columns function found on the data ribbon.

 

[boblarson]

For this type of data you really should have at least two tables. One which has the primary key information (the one) and another which stores the signed data (many). Or else just put an autonumber on the table and let there be more than one of what you are calling the PK even though it doesn't necessarily have to be such in the database.