Can a Append Query move all my data stored in multiple tables to another database with a identical table structure?
Because as I try to work the query, I keep getting prompted to "Select a table" I want to append to, and I don't want to append to just one table...
How would one write a code to open a report (from a form) with 2 criterias.
1.)Retrieves data according to a combo box (I'm good on that one)
AND
2.)Is according to a specific data within a field in a table.
For example.
car - 1
truck - 2
car - 3
bus - 4
car - 5...