• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 470
  • Last Modified:

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
0
Stayer
Asked:
Stayer
  • 3
1 Solution
 
tbsgadiCommented:
Hi Stayer,

In the Report recordSource choose your Query


Good Luck!

Gary
0
 
tbsgadiCommented:
Stayer,

You find the Record Source by going into Design Mode >Properties> Data
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now