Search results

I've read-up on getting random records, but I need a little help. I have a table with 200,000 SSN records. Fields: SSN, Plan Number There are about 100 distinct plans. How can I select a sample (random) SSN for each plan?:confused:

Is there short cut way of discovering what queries, forms, reports or macros are making reference to a particular table? I'd like to make some changes to the layout of a table to make it more efficient, but I know I'll break some queries that rely on the current structure.

I create reports from an Access Db that I've created. I have many sources of data that I gather into my DB. I have several linked tables. As part of my monthly update process, I need to update those linked tables to refresh the data that I am reporting on. I am trying to automate as much as I...