Date Criteria for Report

[C.R. Houk]

Currently I have a report that links to a Query. The
query has a Criteria in the "Date" column for [Date of
Test]. When the report is run a box opens in which the
test date is typed in and the appropriate information is
displayed in the report.
What I want is a little more user friendly method. I am
looking for a way to have the Calander Control open when
the report is run and the user simply clicking on the
appropriate date to satisfy the criteria of [Date of
Test]. Is there any way to do this?

Thank you for your time.

C.R. Houk
charles.houk2<remove>@charleston.af.mil

 

[Allen Browne]

You can use the calander control if you use a form to collect the dates from
the user.

Details in article:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

 

[C.R. Houk]

Okay, this works mostly, except I don't want a date
range. I want to specify a single date only. Using your
format I cannot seem to get it to look for just the single
day I ask for as I normally can with a Criteria specified
in the Query.

Thank you for your Help in advance

C.R. Houk

-----Original Message-----
You can use the calander control if you use a form to collect the dates from
the user.

Details in article:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Currently I have a report that links to a Query. The
query has a Criteria in the "Date" column for [Date of
Test]. When the report is run a box opens in which the
test date is typed in and the appropriate information is
displayed in the report.
What I want is a little more user friendly method. I am
looking for a way to have the Calander Control open when
the report is run and the user simply clicking on the
appropriate date to satisfy the criteria of [Date of
Test]. Is there any way to do this?

Thank you for your time.

C.R. Houk
charles.houk2<remove>@charleston.af.mil

.

 

[Allen Browne]

You can cut the example down so it uses just one text box, and uses " = "
instead of "Between ... And ...".

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Okay, this works mostly, except I don't want a date
range. I want to specify a single date only. Using your
format I cannot seem to get it to look for just the single
day I ask for as I normally can with a Criteria specified
in the Query.

Thank you for your Help in advance

C.R. Houk

-----Original Message-----
You can use the calander control if you use a form to collect the dates from
the user.

Details in article:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

Currently I have a report that links to a Query. The
query has a Criteria in the "Date" column for [Date of
Test]. When the report is run a box opens in which the
test date is typed in and the appropriate information is
displayed in the report.
What I want is a little more user friendly method. I am
looking for a way to have the Calander Control open when
the report is run and the user simply clicking on the
appropriate date to satisfy the criteria of [Date of
Test]. Is there any way to do this?

Thank you for your time.

C.R. Houk
charles.houk2<remove>@charleston.af.mil