Display Parameters on a Report

[piovesan]

Hi there;
I have a report that is based on the following type of query:

SELECT DISTINCT PARCEL_MULTI.ASSET_ID, PARCEL_MULTI.ASSET_TYPE, PARCEL_MULTI.ACQ_DATE, SDEADM_LND_HRM_PARCEL_MULTI.ACQ_TYPE
FROM PARCEL_MULTI
GROUP BY PARCEL_MULTI.ASSET_ID, SDEADM_LND_HRM_PARCEL_MULTI.ASSET_TYPE, SDEADM_LND_HRM_PARCEL_MULTI.ACQ_DATE
HAVING (((PARCEL_MULTI.ACQ_DATE) Between [ Enter start date] And [ Enter end date]));

I would like to have the dates that are entered as the parameter display on the report......... how can I do that?
Thanks!

 

[piovesan]

oops....got the answer to this! Sorry!

 

[dhookom]

IMHO, the answer is don't ever use parameter prompt queries faq701-6763.

Duane
Hook'D on Access
MS Access MVP