Solved

Add query to report in Access2007

Posted on 2009-04-07
5
461 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
  • 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

919 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now