Solved

Add query to report in Access2007

Posted on 2009-04-07
5
465 Views
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.

rgds,

Stayer
0
Comment
Question by:Stayer
[X]
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
5 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24085836
Hi Stayer,

In the Report recordSource choose your Query


Good Luck!

Gary
0
 
LVL 46

Accepted Solution

by:
tbsgadi earned 250 total points
ID: 24085843
Stayer,

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

Expert Comment

by:rockiroads
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
0
 

Author Closing Comment

by:Stayer
ID: 31567429
Works perfectly!

Thanks!
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24091720
Glad to help!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
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…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

617 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