Newbie trying to concatenate a field
I'm trying to create a project number for time-lapse sequences. I want it to start with creation date field, then if the date already exists then I wanted to add a one. i.e. 00 mean only one, 01 = two sequences, etc. This will give each a unique number. So it need to search for any other records with that date. The final part is camera, that data is a pull down menu with four types of camera i.e. canon = 1, GoPro = 2.
I added a graphic to try to make it clear.