Help for another noob (1 Viewer)

Hi all

I want a field in my form (and my table) that automatically updates on each new record, based on the date.

So new entries today start at 1 and increment by 1, then start over tomorrow. i've found a couple of queries online, but i'm not sure what their doing. I'm hoping that i can use this field in the future to calculate a running total per day.


Thanx

May I suggest you have a field called date_created with the default value set to Date(). New records will have the date the record was added, then use a query to count the number of records created each day.