HOW DO I SET UP A DB TO LET ME KNOW WHEN CHECKS ARE DUE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to set up a db for Health and safety in the workplace. This will need
to include the workplace's address and details of who is resposible for the
checks and the dates they are due. can i get it to automatically tell me the
employers that need checking that month?
 
Del,

Contact me at my email address below if you would like outside help to build
your database. I can have your database up and running in a short time at a
reasonable fee.
 
Assuming that you store a date in the database that tells you when the
person is responsible for doing the checks, then it's very easy to write a
report to tell you who is "due" in any given month.

As for automatically, I assume you mean by running a report manually, not by
having the database go generate a report itself.

Just put a field in your table that has the "check month" in it, and then
your report should be based on a query that looks something like this:

SELECT * FROM Tablename
WHERE [CheckDateFieldName] = [Enter the month"];
 
Back
Top