need a date on a report to match the date when ask for date of report

[t m via AccessMonster.com]

i have a report that shows the daily guest list. this list changes every day.
how do i get the date on the form to match the date requested for the list.
IE: i want to print the guest list for sunday on friday how do i get the
report to show the date for sunday.


thanks for the help

 

[Rick B]

Just ask the user what date they want. The report should be based on a
query. Change the "criteria" in your query under the date column to...

=[Enter Desired Date]

 

[t m via AccessMonster.com]

the user does that. but when the report prints they need the dte they entered
to show on the report.

thanks

Just ask the user what date they want. The report should be based on a
query. Change the "criteria" in your query under the date column to...

=[Enter Desired Date]

i have a report that shows the daily guest list. this list changes every day.
how do i get the date on the form to match the date requested for the list.
IE: i want to print the guest list for sunday on friday how do i get the
report to show the date for sunday.

thanks for the help

 

[Rick B]

The date is in the record, just pull it to the header. (if you are only
using one date)

If using a date range, then you would want to use the parameter in an
unbound text field.

In your case, either use the field, ot add an unbound field...

=[Enter Desired Date]




--
Rick B

the user does that. but when the report prints they need the dte they entered
to show on the report.

thanks

Just ask the user what date they want. The report should be based on a
query. Change the "criteria" in your query under the date column to...

=[Enter Desired Date]

i have a report that shows the daily guest list. this list changes every day.
how do i get the date on the form to match the date requested for the list.
IE: i want to print the guest list for sunday on friday how do i get the
report to show the date for sunday.

thanks for the help

 

[Guest]

Rick
I need to do same with date range. Would you please explain further how I
would get the date range entered to show in the unbound text field?

Thanks

The date is in the record, just pull it to the header. (if you are only
using one date)

If using a date range, then you would want to use the parameter in an
unbound text field.

In your case, either use the field, ot add an unbound field...

=[Enter Desired Date]




--
Rick B

the user does that. but when the report prints they need the dte they entered
to show on the report.

thanks

Just ask the user what date they want. The report should be based on a
query. Change the "criteria" in your query under the date column to...

=[Enter Desired Date]

i have a report that shows the daily guest list. this list changes every day.
how do i get the date on the form to match the date requested for the list.
IE: i want to print the guest list for sunday on friday how do i get the
report to show the date for sunday.

thanks for the help