Hi all,
I basically am stumped. I am taking excel ('97, we're strapped for cash!) files and converting them into tables to be imported into this Access (again, '97) DB.
I have about 5 or 6 tables with about 100 reocords each. What I want to do is make either a: query/report that will filter ALL the same records from all the tables. I have tables with the same ID number, but different fields of data in the tables. Example: in table 1 i have: ID, Status, Weight. Table2 has ID, Flow speed, alkalinity. So what I want is a DB that has the unique records with all the fields from the other tables.
I though you were supposed to link them together to do this. I did, but the query's I'm doing are prolly not creative enought to get what I need out of the DB.
Any ideas would be appreciated,
Randy