Automating Reports

[scarnie]

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

[Deep Thought II]

u can try to add a date calculation, and use open script to check and open the popup when the user opens the database.

[Oldfogey]

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.

[-Queue-]

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

should take leap years into account.

[scarnie]

Thanks very much for all your help. Seems to be working as I need it too now.

Susie