Putting in who last updated data and date into a report

[babamc4]

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.

Any help would be really appreciated (have been stuck on this for hours now) :)

[MindBender77]

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

[babamc4]

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

That's it perfect thank you! I am creating my new db at home my pc in work has died and gone to HELL with the problems it caused me. Once my new pc is up and running I will create the security file to have a log in screen and do what you suggested. Just one more question though how do I get that information on to the report that I am running (2xMonthly reports of ineligible patients and eligible patients). Thank you so much!

Aine

[MindBender77]

That's it perfect thank you! I am creating my new db at home my pc in work has died and gone to HELL with the problems it caused me. Once my new pc is up and running I will create the security file to have a log in screen and do what you suggested. Just one more question though how do I get that information on to the report that I am running (2xMonthly reports of ineligible patients and eligible patients). Thank you so much!

Aine

You could add a date field to your patient table then join/cross-reference those dates with those in the security table. Finally, run your report off of this query. So your end result will be a report of all patients eligible, ineligible and which users modified the records in the same month.

Hope this Helps,
JS

JS

[babamc4]

You could add a date field to your patient table then join/cross-reference those dates with those in the security table. Finally, run your report off of this query. So your end result will be a report of all patients eligible, ineligible and which users modified the records in the same month.

Hope this Helps,
JS

JS

That is perfect and it would completely comply with our legislation (which is very very tight) again thank you for all your help.

Aine :)