Using query parameter in Access report
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 t开发者_如何学Pythonhe report - ie. the report says "Sales for Period:" and then shows the "from date" and the "to date" that the user input.
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.
精彩评论