Jump to content

Automating Reports


This topic is 7196 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a database which contains equipment and a date tested. As an example equipment may need tested annually. How do I generate a reminder that a particular piece of equipment is due for test by either automatically producing a weekly/monthly report or having a pop-up box appear on screen to remind the user that a piece of equipment is due to be tested.

Any help greatfully received.

Thanks

Susie

Link to comment
Share on other sites

I'd use a calculation field along the lines of this -

case(Get(CurrentDate)- TestDate > 365, "Equipment needs testing", "")

Colour the text red and have no borders arounbd the field.

You can play a bit with the calculation to allow for leap years if that's important and also maybe modify the message according to how overdue the testing is.

Link to comment
Share on other sites

Case( Date( Month(Get(CurrentDate)); Day(Get(CurrentDate)); Year(Get(CurrentDate)) - 1 ) >= TestDate; "Equipment needs testing" )

should take leap years into account.

Link to comment
Share on other sites

This topic is 7196 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.