Search results

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...