Adding a query to a report

[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?

 

[Maverick]

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.

 

[Tom van Stiphout]

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

 

[Duane Hookom]

Actually I think Maverick meant "Record Source" rather than "Control Source".
A Control Source is used to bind controls to a field or expression.

 

[Emma]

That worked perfectly!

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

 

[Maverick]

Indeed. My fingers were working faster than my brain. Thanks for the catch.

 

[Maverick]

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.