How to report on the most recent record
Are you looking for a notification that the record has been created and will appear in the report?
I want to automate the reports that are generated for the BoD's report so that the office staff, who are very busy, don't have to worry about running the reports manually. I hope this clairifies my need.
If you set the date range on the report to be the last 45 days, you'd be sure to get only one record. (This assumes that the data comes out roughly every 30 days.)