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.

is this homework? also, you should be able to find this answer on google — CheeseConQueso
– CheeseConQueso, Commented Mar 23, 2010 at 23:19
it's a function I would like to add to an assignment at college, so kind of yes. Can't find an answer on google at my level unfortunately. — Dave
– Dave, Commented Mar 23, 2010 at 23:50
You can google anything instead of coming to SO-what's the point? Homework questions are OK when the user has part of the solution or made an attempt. — JeffO
– JeffO, Commented Mar 24, 2010 at 1:31

Vincent Ramdhanie · Accepted Answer · 2010-03-24 02:30:29Z

2

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.

answered Mar 24, 2010 at 2:30

Vincent Ramdhanie

103k23 gold badges143 silver badges196 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

David-W-Fenton Over a year ago

That's a really nice tutorial -- much better than the usual MS-hosted stuff.

Collectives™ on Stack Overflow

Using query parameter in Access report

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related