Using query parameter in Access report

Question

I have a very basic access database where a query returns the sales made within a set start date and a set end date.

The dates are set with two pop up boxes for the user to enter, first the start date, and then the end date.

I have a report running off the back of this.

How can I (using VBA) get at these dates then display them on the report - ie. the report says "Sales for Period:" and then shows the "from date" and the "to date" that the user input.

Answer 1

You may find this tutorial helpful. It shows how to use a form to capture parameters for queries and reports and access the parameter values in VBA.