Can I create reports that use runtime variables?

[RhinoCan]

I'm fairly new to Access and I'm trying to find out if it's possible to have a report that contains variables which drive what is in the report?



Specifically, I have a table of Sales data where each row contains a single sale. The sale consists of a date (containing Year, Month and Day), an item, and a quantity. There are only a maximum of 4 different items sold by this business. I want my report to list only sales for a specific week, where I specify the begin and end dates of the week when I execute the report. In other words, the begin and end dates are unknown to the report when I execute it and it should prompt me for those values, then display them on the report. Therefore if I run the report today and want information about last week, I would specify a begin date of 2015-12-13 and and end date of 2015-12-20. When I run this report next week, I'll give it the begin and end dates for THIS week and get a report on what sales I had this week.

Is that possible? I've been poking around in Access but don't see any options for variables like this.

[ranman256]

In full Access, design a form for users to pick dates, depts, and select a report.
once entered, the query uses the items in the form to pull the data.
The user picks a report name from a list box, adds a date range if needed.

then Runtime can run these.

[RhinoCan]

In full Access, design a form for users to pick dates, depts, and select a report.
once entered, the query uses the items in the form to pull the data.
The user picks a report name from a list box, adds a date range if needed.

then Runtime can run these.

Thank you for confirming that what I want is possible; that's half the battle right there ;-)

I've put together a form that prompts for the dates - I display them in a list box so that the user can select the one he wants - and have created a RUN button that, when pressed, executes the query that gets the data. I'm not clear one critical thing though: how do I get the two selected dates (the date the week began and the date the week ended) to the query so that it only gets the rows for that week?

If it's too involved to describe in a post, I'd be perfectly happy if you could point me to a tutorial or video that shows how to get a variable from a form and pass it to a query.

[June7]

Review http://datapigtechnologies.com/flash...mtoreport.html

I don't use dynamic parameterized queries. I prefer VBA to build filter string http://www.allenbrowne.com/ser-62.html