Hi All
I'm creating a new database for a patient log to include patients who have been screened for trials who are eligible and not eligible. Every month I need to run a report saying who is eligible and not eligible. I have tables, queries set up and have set up the reports but I need to add into the report who last updated the data and I can't figure out how to do this. Do I need to create an 'update' table and try (I don't know how) to link it in a query with other data.
I am using access 2000.
Does your DB have a LogIn screen. If so, you could archive each persons LogIn time and LogOut time. Also, when the person, who is logged in, goes to a form, you could have each form they open run an update query. This update query could write back to a table the timestamp and form name. This way, you can aways view who was where and when.
Hope this points you in the right directions,
JS