query by form to make records

[mbhw99]

I've seen a lot of answers about these questions, but I need a little help combining all of these. I have a little experience with access, but not too much.

I'm trying to make a form to search one field (Zone) to return 10% of the results from another field (Location) from table "all locations" in random order on a continuous form. These results would make one record into a different table "Warehouse Storage Audit" for additional data entry/editing. The fields in the later table are named the same as the first.

I appreciate your time and I'll try to answer any questions.

 

[jdraw]

Here's an article on Access and Random numbers which should be of value to you.
http://www.techrepublic.com/blog/ho...random-set-of-records-in-microsoft-access/149

 

[mbhw99]

That does help. I've just gotta figure out how to incorporate it with the rest of the issues. lol

Thanks!