Blank Maximum Record ID
Hi, I'm trying to create a summary field of the maximum record ID for a table, but the result is a blank field I have a table called "Offices" that I would like to track the maximum record ID# for ...
Forum Discussion
Thanks for the help!
I added an "office" to the Records table and the Maximum record ID populated, but this is tied to a single Office Record. The Maximum Record ID field does not update when I add new records to the Office table.
I'm trying to keep track of the maximum record ID for the Offices table so I can automate the deletion of older records in the table. I would use creation date, but I sometime generate multiple new records in a day and I'm trying to clear out old records as new ones are created.
Am I approaching this currently or is there a better way?
I added an "office" to the Records table and the Maximum record ID populated, but this is tied to a single Office Record. The Maximum Record ID field does not update when I add new records to the Office table.
I'm trying to keep track of the maximum record ID for the Offices table so I can automate the deletion of older records in the table. I would use creation date, but I sometime generate multiple new records in a day and I'm trying to clear out old records as new ones are created.
Am I approaching this currently or is there a better way?