adding query report

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Adding a query to a report

Adding a query to a report

resolvedResolved · Urgent Priority · Version 2003

Helen has attended:
Access Advanced course

Adding a query to a report

I am trying to modify a report to show some of the financial details for a particular record on a particular year.

As I understand it, theSQL should look a little like this:
SELECT [Tech Track Fax Back Details].BaseYear
FROM [Tech Track Fax Back Details]
WHERE ((([Tech Track Fax Back Details].BaseYear)=2002));

How exactly do I add this to a report? (It does not seem to work to add it directly into the 'Control Source' box.)

This is somethign that I have to get done today so if there is any way I can get a fast answer on this it would be very much appreciated.

Thanks.

RE: Adding a query to a report

Start a report from scratch:
Use the Report Wizard and when going through the initial set up it will ask you which table/query you want your report to be based on. Select your query and then add the necessary fileds etc from that query.


 

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips


Server loaded in 0.13 secs.