Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.
Solved
Add query to report in Access2007
Posted on 2009-04-07
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
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
[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
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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder.
But why not let Windows retr…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
Suggested Courses
Course of the Month7 days, 14 hours left to enroll
715 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.