AnsweredAssumed Answered

Displaying number of records in a found set

Question asked by Guildy on Apr 1, 2009
Latest reply on Apr 1, 2009 by Orlando

Title

Displaying number of records in a found set

Post

Hello

 

I have looked through the forum and can't see any previous posts on this question.

 

In the UK, property owners who rent property must have a gas safety check each year. I have developed a straight forward database where you enter the date of the last check carried out, then OnLayoutOpen finds records where the next check is due within 30 days as a reminder.

 

It would be nice to have a summary screen on a main menu which can find the number of records in this found set and display them. E.g. "you have [insert number of gas safety checks due] due within the next 30 days"

 

Any thoughts on how to do this? It is most likely with this being a summary page, the table will have no records and no relationships.

 

Many thanks for any assistance that can be offered.

 

Adrian

Outcomes