开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜