Reports with beginning and end date prompts

[natedog51]

I'm trying to create a report with 2 subreports embedded. The two subreports are generated from the query. I have one query with detail and the other query is a subquery of the first query that summarizes the data.

In the first query with detail, I have the date criteria as "Between [Beginning Date] And [Ending Date].

However, when I run the report I'm prompted two times to enter the beginning and ending dates.

I've tried adding the "Report Date Range" form but I'm not a code writer so I keep getting errors.

I'm trying to create a report that shows projects and their current status and then the projects and their current distribution among employees (i.e. joe has 15% of the projects in pending status).

Any thoughts?

 

[Rich]

Use a form to pass the Parameters to your query, keep the form open while the Report loads

 

[natedog51]

Thanks for your suggestion, but what type of form specifically. I hate to sound dumb, but I'm still learning Access.

 

[natedog51]

Update - I was able to get a form to hold the dates - thanks for the suggestion, Rich!