469,613 Members | 2,223 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,613 developers. It's quick & easy.

show last updated date on reports

Does anyone know how to have Access put the "last updated" date on a
report? I have a table of our university's athletic events, grouped by
each sport per page. I'm trying to get the report to print the last
date updated, even if the secretary who does the input has to put it in
- hopefully i can set it to prompt her or do it automatically.
If anyone has an idea, I'd really appreciate it. I can give further
details of the set up, but the basics are:
Events table holds all data, Sports table list each sport and I've made
an "Updated" field in that table. The Events table uses the Sports
table sa a lookup for that field in Events.
Any help would be greatly appreciated!
Thanks,
Eddie

Aug 8 '06 #1
1 1884
I guess I don't understand your problem ...
You do have an "updated" field for each sport in the table?
So you only need to have the "updated" field in the query for the report.
What am I missing ??

Arno R

<ea**@nyu.eduschreef in bericht news:11**********************@m79g2000cwm.googlegr oups.com...
Does anyone know how to have Access put the "last updated" date on a
report? I have a table of our university's athletic events, grouped by
each sport per page. I'm trying to get the report to print the last
date updated, even if the secretary who does the input has to put it in
- hopefully i can set it to prompt her or do it automatically.
If anyone has an idea, I'd really appreciate it. I can give further
details of the set up, but the basics are:
Events table holds all data, Sports table list each sport and I've made
an "Updated" field in that table. The Events table uses the Sports
table sa a lookup for that field in Events.
Any help would be greatly appreciated!
Thanks,
Eddie
Aug 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.