Select a date range for reports

[Forbes]

Attachment 27860

I have attached this mock version of the project that I am working on, fairly straight forward and everything runs nicely.

The database is simple, it has a form on one end for employees to submit conditions and another form for mgmt to print the reports of those conditions from 3 seperate departments.

My question is looking at the printreports form is there a way that when clicking on one of these reports to print a dialog box can come up asking for the date range based on the timestamp of the condition?

[Micron]

Easiest would be to create date parameters in the query that the report is based on. Best would be to provide unbound text box date fields on a form. The former provides no assurance that a valid date will be entered. Having said that, I'll take a look at your attachment.

[Micron]

See attached example. Your report query (adminRQ) Year([timestamp]) field would probably be the place to put the dates (not done in the attached). So like

SELECT reports.cond, Count(reports.cond) AS CountOfcond
FROM reports WHERE (((reports.condemp)="Salene" Or (reports.condemp)="Sierra117") AND 
((Year([timestamp])) Between [Forms]![reportprint].[txtBeginDate] And [Forms]![reportprint].[txtEndDate]) AND 
((Month([timestamp]))=Month(Now())))
GROUP BY reports.cond;

Conditions mock2.zip

[Forbes]

Thank you Micron, I was able to complete this using a guide online and replaced the old info in the query involving time stamp and it worked great, I appreciate you helping me.

Link to guide http://allenbrowne.com/casu-08.html

[Micron]

You're welcome.