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
StayerAsked:
Who is Participating?
 
tbsgadiCommented:
Stayer,

You find the Record Source by going into Design Mode >Properties> Data
Gary
0
 
tbsgadiCommented:
Hi Stayer,

In the Report recordSource choose your Query


Good Luck!

Gary
0
 
rockiroadsCommented:
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
0
 
StayerAuthor Commented:
Works perfectly!

Thanks!
0
 
tbsgadiCommented:
Glad to help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here