Adding a query to a report

  • Thread starter Thread starter Emma
  • Start date Start date
E

Emma

Hello, I have several existing reports which were made based on a table.
Unfortunately I now have some variables in a query I would like to add to
these pre existing reports. I only know how to use the report wizard and I'm
using 2007. How do I add a query to a report?
 
You would replace the existing Control Source (I'm assuming it's a table)
with the query. Be sure that the query has all of the existing fields (from
the original Control Source) for the report as well as the new stuff.
 
On Thu, 4 Sep 2008 06:31:01 -0700, Emma

The first step in the Report Wizard allows you to select either a
table or a query.

-Tom.
Microsoft Access MVP
 
Actually I think Maverick meant "Record Source" rather than "Control Source".
A Control Source is used to bind controls to a field or expression.
 
That worked perfectly!

Tom van Stiphout said:
On Thu, 4 Sep 2008 06:31:01 -0700, Emma

The first step in the Report Wizard allows you to select either a
table or a query.

-Tom.
Microsoft Access MVP
Click to expand...
 
She doesn't need to recreat the report using the wizard. All she has to do is
change the Record Source (the brain caught it this time Duane) in design mode
of the report. As long as the fields match up, she is good to go by just
adding the new controls to the existing report.
 
Back
Top