G
Guest
Here's my situation...
I have about 20 pieces of equipment that must be maintained. We do 'weekly
checks' on all of them. I have built a database that has tables for each
piece of equipment, and gives me reports on deficiencies, error messages, and
the like (regardless of date).
However, sometimes we get cought up in work, and one guy will do some checks
on Monday, and another will finish up on Tuesday or Wednesday (or both). I'm
looking to be able to pull up a report with all data entries for the week,
regardless of what day they were entered.
Currently, the date field autopopulates and is hidden from the guys. Is
there a simple way to do this? I considered a second field in each table
that lists the monday of that week or even the week number based on the
'today's date' field, but I don't know how to do it!
Any help would be great. I am at the 'beginner' level...shocked I've made
it this far!
Thanks in advance,
Kim
I have about 20 pieces of equipment that must be maintained. We do 'weekly
checks' on all of them. I have built a database that has tables for each
piece of equipment, and gives me reports on deficiencies, error messages, and
the like (regardless of date).
However, sometimes we get cought up in work, and one guy will do some checks
on Monday, and another will finish up on Tuesday or Wednesday (or both). I'm
looking to be able to pull up a report with all data entries for the week,
regardless of what day they were entered.
Currently, the date field autopopulates and is hidden from the guys. Is
there a simple way to do this? I considered a second field in each table
that lists the monday of that week or even the week number based on the
'today's date' field, but I don't know how to do it!
Any help would be great. I am at the 'beginner' level...shocked I've made
it this far!
Thanks in advance,
Kim