Solved Two Date Report Print (1 Viewer)

[smtazulislam]

Hello Dear,
Any help will appreciate.

I attached my Query And Form
I want to Report print out by Criteria Employee ID and Start Date and End Date.

 

[CJ_London]

criteria for start from would be something like

>=forms!report!txtStart

and the end date

<=forms!report!txtEnd

bad idea to have spaces in field names and using reserved words (like Report as a form name)

alternatively apply the criteria as a parameter to your openreport command

 

[smtazulislam]

criteria for start from would be something like

>=forms!report!txtStart

and the end date

<=forms!report!txtEnd

bad idea to have spaces in field names and using reserved words (like Report as a form name)

alternatively apply the criteria as a parameter to your openreport command

Thank you so much.
Its worked.
but also want by enter EmployeeID then Only show this employee Record only.

 

[CJ_London]

to show for an entered employee or if that control is blank

=forms!report!txtEmployee OR forms!report!txtEmployee is Null

 

[smtazulislam]

Thanks you so much !
Its done