How do I add Variable date to Report Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to accept and then print
date on Report Header. How can I do it?

I should be able to accept the date and append it
to Page Header and also use it in Query to
fetch records greater than that date.

Thank you in advance,
-M
 
Me said:
I want to be able to accept and then print
date on Report Header. How can I do it?

I should be able to accept the date and append it
to Page Header and also use it in Query to
fetch records greater than that date.
Click to expand...


Set the query date field's criteria to something like:
[Enter start date]
Click to expand...

THen the report's header can display that date by using a
text box with the identicla prompt string:

="Starting date: " & [Enter start date]
 
Marsh,

This works!!!

Thank you,
-Me

Marshall Barton said:
Me said:
I want to be able to accept and then print
date on Report Header. How can I do it?

I should be able to accept the date and append it
to Page Header and also use it in Query to
fetch records greater than that date.
Click to expand...


Set the query date field's criteria to something like:

>[Enter start date]

THen the report's header can display that date by using a
text box with the identicla prompt string:

="Starting date: " & [Enter start date]
Click to expand...
 
Back
Top