Unique Field Format for a Calculated Field
I am trying to create a new Calculated Field in a table that populates the field in a specific format. The expression I am using is [Intake Date] & [Intake Count] is for a Field I named Intake ID. The new field will be used as the Primary Key for the Table which basically counts the record entries for a given day and converts them into a reference number. To illustrate an example, I want the combination of the Intake Date input of 2/14/2022 and the Intake Count (an AutoNumber) of 1 to read as 202202140001 in the Intake ID Field. This represents yyyymmdd####. I have played around with it a bit, but cannot get it to display the way I want. Any suggestions or examples would be greatly appreciated.