Unanswered: Can one query take the results from another query?
Hi, I am pretty much a new MS Access user, but slowly learning the ropes. If anybody could answer my question below, I would appreciate it:
This is what I am looking for:
One query takes a search criteria and spits out all records that match the criteria, but displays only a few select fields. (This is done with the intend to give the dB user an initial brief idea about what to expect in each record). The results of query 1 could be in a form or a report (?).
Then, the user selects the records (from query 1) for which he wants to see full details, he can click on a button, for selected records and a second query provides him/her with ALL fields (of the records he selects).
The whole idea is break up a search into 2 steps - (1) find and make a list of all records that match a criteria, showing just a few fields at first (2) From this list down select a few records for which ALL fields are produced in a report.