Hi, this might be a simple bogal but, I created a query that selects some records bases on 3 fields. (I have a number of fields in a number of tables. All my data is linked together via Accesses very own ID auto-number PK.)
Out of my 75,000 odd records 251 pop up fitting my criteria. Now, I wish to copy those records and paste them into another DB. (The of DB is just a backup, so tables and fields are the same).
If I highlight the records in my 3 fields query, will all the other connected data (record) be copied as well?
Can anyone suggest a better method if this is not cricket?
TIA
Aron (newbie)
Out of my 75,000 odd records 251 pop up fitting my criteria. Now, I wish to copy those records and paste them into another DB. (The of DB is just a backup, so tables and fields are the same).
If I highlight the records in my 3 fields query, will all the other connected data (record) be copied as well?
Can anyone suggest a better method if this is not cricket?
TIA
Aron (newbie)