Prompting for date

thompson905

Registered User.
Local time
Today, 00:09
Joined
Mar 26, 2008
Messages
15
Hello All- I am still very new to access so please bear with me. I need to be able to prompt the user for a date before running the report. I want the user to be able to use a date picker for the date. I then need to exclude all items but those in which [datepaid] = user entered date.

I am sure this is possible but I cant think of how to get started. I can get a prompt using a text box with a label in the controlsource but thats not a date picker. Then i have no clue where to start to exclude the rest of the items in the report except those that match the user picked date.


Also I would like to include a [type] field that cannot be blank to be included in this report. Sorry I am all over the place with my request. Thanks for any input you have its much appreciated.

Tom
 

Users who are viewing this thread

Back
Top Bottom