posted 13 years ago
I have a Table entitled rpdnotification that has the following fields - subject, authority, startdate, narrative, and rundays. It prints out on a report for x number of days (Normally the user will select 5 days). Sometimes there are no notifications. Is there a way to load a message into the subject field that if the table has 0 records than subject would equal "None at this time"?