I need to change the data source on a report from table to query

[Nate]

I am doing medical forms for a volunteer group so that I can print out the
forms each year. I do this so that the returning volunteers don't have to
fill out a whole new form each year, but just mark any chnges that are
necessary. My problem now is that I want to batch print certain forms. Is
there a way to either change the data source for an existing report from a
table to a query, or make a new report from a query, but using the old
report layout as a template? The reason I ask, is because laying out all of
the fields in a new report is extremely time and labor intensive as it needs
to fit an existing form.

 

[Arvin Meyer]

Go into the design view of the report, and open the property sheet. Click
on the Data tab, then in the Recordsource property. Use the down arrow to
change the recordsource to another table or query from the list. Or type a
sql statement for the report. You can also use code for the recordsource.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[John Vinson]

I am doing medical forms for a volunteer group so that I can print out the
forms each year. I do this so that the returning volunteers don't have to
fill out a whole new form each year, but just mark any chnges that are
necessary. My problem now is that I want to batch print certain forms. Is
there a way to either change the data source for an existing report from a
table to a query, or make a new report from a query, but using the old
report layout as a template? The reason I ask, is because laying out all of
the fields in a new report is extremely time and labor intensive as it needs
to fit an existing form.

I'd suggest making a copy of the Report - just select it in the design
window and type Ctrl-C then Ctrl-V to copy it.

Then open the copy in design view, view its Properties, and do as
Arvin suggests - replace the table name with the query name.


John W. Vinson[MVP]