How to generate two reports from one query

[robertedmundwalker]

Hello forum. I am new to access. I am trying to generate two reports from one instance of a query.
My Table has three record Columns. ID (access generated key) Question and Answer.
My Query pulls 10 random records from the table.
My first Report displays the [ID], [Question] and [Answer]<- (not visible) of the 10 random records
My second report "should" display the answer for each of the 10 random records generated by the Query (to serve as an answer key). Instead it runs the Query again and show 10 answers that do not match the first query.
I have tried setting the data source for the second Report [Answer] to the first Report [Answer], but this gives me the same thing 10 times (last record the Query produced) from the first Report.


I thought I should be able to produce two Reports (with different Columns from a Record on each) from one instance of running a Query.
Any help would be appreciated.

Robert

[June7]

That's the nature of randomizing. You run report and get random records. Each report runs their own instance of the query.

A solution will likely involve writing records to a 'temp' table and that table is used as source for reports.

[robertedmundwalker]

Thank you June7. After reading you reply I looked up how to change a SELECT Query (that I already had) to a MAKE TABLE Query and linked my multiple reports needed to the new table name that is created.

[June7]

My preference would be to use a 'temp' table - table is permanent and records are temporary. DELETE records from table at beginning of procedure, INSERT new records. If db is multi-user split design, the temp table would be in the frontend so users will not conflict.

Continually creating and deleting tables is changing db design. Recommend avoid procedure that programmatically changes db design.