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.