Count filed Zero and Date printing on Report

[eshaan]

I have a report that is generated Emp codes and working years information.If employee retired two years ago search criteria needs results after two year.

My date values and Emp Code parameter values are coming from Query parameter. Example: between (Enter start date) and (End Date), (Enter Emp Code).

If no data is in the report I used with the On No Data event and also HasNoData but can't get the results I want. I want to be able to put the search Criterias that I Started to search on the report.

Example if I search for Emp Code retired from 09/30/00 to 09/30/04. I want to display on the report"No Data found" Emp code:12 from 09/30/02 to 09/30/04.

Count field has to show Zero instead of Error.

Please help me.
Thanks.

 

[dhookom]

Don't use parameter prompt queries. Use references to controls on a form. This provides much more power and flexibility. You can bind a control on the report to something like:
=Forms!frmRptSlct!txtStart

Duane
MS Access MVP
Find out how to get great answers faq219-2884.