Use query results from report to make table

[DanG]

Hello,

I have a query that prompts the user for input to generate a report.
I would like to in essence copy that same record set and append it to a different table (archive table).

Not quite sure how to go about it.

Thank you

 

[elbweb]

do you mean copy it manually or have a code that does it automatically when the report is created?

 

[mhartman]

Hello

If your query is returning the records you want, then what you want to do is run a MAKE TABLE query.

In query design mode, select Query, MAKE TABLE.
Regards
Mark

 

[DanG]

This will need to be automated (on events).
I have a form that has two of the values the query requires and then I push the button to open the report.
So when the report is open those are the records I want to go to the "Archive" table.
I know a bit of code and I think that is the way to go, but I don't really have a handle on recordsets. I know you can copy a forms recordset, but what about a reports or am I off track on how it works?

Thank you very much!

 

[elbweb]

well i might have something that could interest you, a little bit ago i posted a good example of how to use and manipulate recordsets, maybe you will be able to find there what you want/need

as always feel free to come back if you need some more help.

http://www.access-programmers.co.uk/forums/showpost.php?p=510223&postcount=3

 

[DanG]

I'll check it out.

Thank you very much!