Problem 1:
I am new at this,
created a database in access to retrieve certain records. the problem i am facing is that i want to retrieve some records in a certain criteria but not all the records. Let me explain. I have an inventory with different columns for qty, type, etc... in the location column, i would like to retrieve some records in a certain location (like bin 01 row 05 and up, but not rows 04 to 01).
Is there any way i can do this?

Problem 2:
created a union query to combine 3 different tables together. this combines all data in location "car". the problem is that when i run the query, made macro to output this data to excel, which in turn is formatted via macro in excel to have document in format we want. we then add a location in the last column as to where we want the "car" to be emptied.
the problem is that when we run the query again, it gathers the information from a linked table in the inventory system which have no locations. therefore, we lose all information entered in excel.
Tried to create a .txt file to link to database, but when we run the query, it overwrites the .txt file (with no location). Tried an update query to update a made up table but doesn't work either.

Can anyone help me on any of these issues? thanks