Formatted Report Template from a Query

[victoriarai77]

I’m having some report problems. I’m trying to use my database reports to send the same bits of information out a little at a time. I made a query to select the data to be exported by the ID. I am trying to make a report template so that each time I run the query, I can get the same report. Is this possible?

 

[theDBguy]

Hi. I'm not sure I understand the question. Can you post the SQL statement of the query?

 

[zeroaccess]

I’m having some report problems. I’m trying to use my database reports to send the same bits of information out a little at a time. I made a query to select the data to be exported by the ID. I am trying to make a report template so that each time I run the query, I can get the same report. Is this possible?

Just so we're clear - do you mean the Access object "Report"? So you are making a Report based on a query as a record source?

 

[Uncle Gizmo]

It sounds to me you would like something like this:-

Generate Multiple Reports - Nifty Access

Generate Multiple Reports This blog came about because of an answer I gave to a particular OP's question. Therefore the code isn't generic, it is designed for a specific situation, like most examples! However I hope there's enough information here for you to follow what's happening. Multiple...

www.niftyaccess.com

The sample database on my website is available for free.
Contact me for details on how to get it for free.

 

[Bullschmidt]

I am trying to make a report template so that each time I run the query, I can get the same report. Is this possible?

Well in a particular report you can set its RecordSource property to be a particular query. Then every time you open the report it will use that query. And if the query automatically asks for an ID, that part will still work too...