Calculated field with resetting increments by time period

I'm fairly good at Excel, but brand new to Access - and I'm discovering that there are enough differences between the two that I might be worse off than someone with no knowledge at all!

I'm looking to create a calculated field in a table that increments by date. That is, each day will have a similar results, but resets each day. For example, a bunch of records created today will have results like
2017-11-27-001
2017-11-27-002
2017-11-27-003

And records created tomorrow will autopopulate as
2017-11-28-001
2017-11-28-002
2017-11-28-003

Is this possible without using VBA?

this can be done with zero programming. Set the date field to date/time ,
with default = now()
format = General Date

the records can now be ordered in time order. It does not start at 1 like your example but it is equivalent with zero programming.

if you want to use vba:

Now when you need to make a new work order for a new day,
get the MAX value for THAT date,
then either start from 1 (if null) or add +1 if this day exists:

Please Login or Register  to view this content.

make a query to pull the [RWO] and the bare date values in the RWO. (left 5, no day#)
in the query: qsDateVals,
SELECT [RWO],(Left([RWO],5)) AS DateVal FROM tData;

Originally Posted by ranman256

this can be done with zero programming. Set the date field to date/time ,
with default = now()
format = General Date

the records can now be ordered in time order.

Yes, that would work for a table that already has data in it...but what I'm really trying to do is generate a unique ID that increments, whenever a new record is added. And it does need to start at "001".

I also should have been more explicit, in that thought the date may be encoded in the field, it won;t be any of the standard date formats, and I'll be adding some text to the field (that is, the final text should look like "GTO-YYMMDD-001", but will be treated as a text field.