Reports based on multiple criteria

[kets0985]

Hello,

I am in the learning phase for MS Access reports. I have a datasheet which contains the employee daily activities.

I need a report when either or both criteria is selected. For ex..criteria1 is Start date and End Date and criteria2 is Employee Name.

Output of the report should be based on the selection of the criteria ,as I said either or both.

Can somebody help me on this?

 

[pbaldy]

Use the Nz() function around each date criteria, and this for the employee:

http://access.mvps.org/access/queries/qry0001.htm

 

[kets0985]

Thank you pbadly.
I will definitely try this and will come back if need something.

 

[pbaldy]

No problem.