Stayer
asked on
Add query to report in Access2007
Hi experts,
I want to create a report from scratch ("Blank Report"). However, I do not know where I can add the query fields I want in the report. If I choose "Add Existing Fields" only table - fields are displayed.
Anyone who can suggest me how to find the query (which I of course already have made) and insert the query field in my report.
rgds,
Stayer
I want to create a report from scratch ("Blank Report"). However, I do not know where I can add the query fields I want in the report. If I choose "Add Existing Fields" only table - fields are displayed.
Anyone who can suggest me how to find the query (which I of course already have made) and insert the query field in my report.
rgds,
Stayer
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
One simple way is to use the report wizard
if u click on create then select report wizard, you will be prompted for tables and queries. Select it from the dropdown. Then select your fields and click Next, then follow the wizard
if u click on create then select report wizard, you will be prompted for tables and queries. Select it from the dropdown. Then select your fields and click Next, then follow the wizard
ASKER
Works perfectly!
Thanks!
Thanks!
Glad to help!
In the Report recordSource choose your Query
Good Luck!
Gary