By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,497 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Putting in who last updated data and date into a report

P: 14
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) :)
Feb 5 '08 #1
Share this Question
Share on Google+
4 Replies


MindBender77
100+
P: 234
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
Feb 5 '08 #2

P: 14
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
Feb 6 '08 #3

MindBender77
100+
P: 234
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
Feb 6 '08 #4

P: 14
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 :)
Feb 6 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.