add data valid thru date on report

G

Guest

The report I run comes from information that needs to be updated manually
each week. Unfortunately, we don't always take the time to stay on top of
this and we get behind. I want to add to the report a date that tells me the
information is valid thru XXXX date. I could then manually supply the XXXX
date depending on how current we are with our data entry.

If I could get a text box to pop up when I open the report, that asks for
the valid thru date, that would be perfect. I am stumped as to how to do
this.
 
J

John Spencer

Add a control to the report
Set the control's source to [Accurate through?]

When you run the report, you should get a dialog asking for [Accurate
Through?}. Enter the value you want to see.

Now, that is ok, but if you have a date field on what you are entering then
perhaps you could grab that to get the valid date?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
M

Marshall Barton

Doreen said:
The report I run comes from information that needs to be updated manually
each week. Unfortunately, we don't always take the time to stay on top of
this and we get behind. I want to add to the report a date that tells me the
information is valid thru XXXX date. I could then manually supply the XXXX
date depending on how current we are with our data entry.

If I could get a text box to pop up when I open the report, that asks for
the valid thru date, that would be perfect. I am stumped as to how to do
this.


If that's all you want, then just add a text box to the
report and use an expression like =[Enter Date]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top