How to populate a new table with values from another table based on a specific values for a field in MS ACESS
Posted on 2011-03-19
I have a 90,000 db that I want to trim down to a smaller version based on the cashierid...I have 10 cashierids that I want to move all records assocaited to them in to a new table...
SELECT * into smallerTable
WHERE cash_id is "suzy1123" or "barb2523"
obviously I am not sure of the code...help appreciated