Reports with beginning and end date prompts

natedog51

New member
Local time
Today, 15:44
Joined
Jan 24, 2007
Messages
8
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?
 
Use a form to pass the Parameters to your query, keep the form open while the Report loads
 
Thanks for your suggestion, but what type of form specifically. I hate to sound dumb, but I'm still learning Access.
 
Update - I was able to get a form to hold the dates - thanks for the suggestion, Rich!
 

Users who are viewing this thread

Back
Top Bottom