Add query to report in Access2007

Posted on 2009-04-07
Last Modified: 2013-11-28
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.


Question by:Stayer
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
LVL 46

Expert Comment

ID: 24085836
Hi Stayer,

In the Report recordSource choose your Query

Good Luck!

LVL 46

Accepted Solution

tbsgadi earned 250 total points
ID: 24085843

You find the Record Source by going into Design Mode >Properties> Data
LVL 65

Expert Comment

ID: 24085851
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

Author Closing Comment

ID: 31567429
Works perfectly!

LVL 46

Expert Comment

ID: 24091720
Glad to help!

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question