ClioSport.net

Register a free account today to become a member!
Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

  • When you purchase through links on our site, we may earn an affiliate commission. Read more here.

MS Access Question



  Tappd'd RS
Hi Guys,

I have a query "Qry_Equipment Calibrated" that looks at a field "Date of Calibration" in a table and prompts the user to enter a date range. The query criteria is:

Between [StartDate of Calibration - DD/MM/YYYY] And [EndDate of Calibration- DD/MM/YYYY]

In essence this shows me the pieces of equipment calibrated over that date range.

I have the query set up to a report so I can see this information in a nice format.

Now my question: Can I set up the Report Header to show the "StartDate of Calibration - DD/MM/YYYY" and "EndDate of Calibration - DD/MM/YYYY" that the user entered?

Cheers.
 
  Tappd'd RS
Managed to sort it. :)

I had to create some new expressions in the query and referenced these in the report.
 


Top