Hi,
I want to create a database where i can enter date, and serial number for customers. I want a third field which uses entered date as ddmmyyyy and joins it with serial number making it into a unique registration number.
Example - Date of entry - 1/30/2019
. Serial number - 22
. The registration number should be 3001201922. Is there a way to do it?
I have tried using =Format([DateField], "ddmmyyyy")&[SerialNo]
in default value of general tab of table properties but I get error of "The database engine does not recognize either the"DateField" in valuation expression, or the default value in table 'Table1'. "
I also tried using forms. I used the above formula in Property Sheet>Data>Control Source. It works, however the value doesn't show up in tables.
Can anyone guide me what I am doing wrong..
I want to create a database where i can enter date, and serial number for customers. I want a third field which uses entered date as ddmmyyyy and joins it with serial number making it into a unique registration number.
Example - Date of entry - 1/30/2019
. Serial number - 22
. The registration number should be 3001201922. Is there a way to do it?
I have tried using =Format([DateField], "ddmmyyyy")&[SerialNo]
in default value of general tab of table properties but I get error of "The database engine does not recognize either the"DateField" in valuation expression, or the default value in table 'Table1'. "
I also tried using forms. I used the above formula in Property Sheet>Data>Control Source. It works, however the value doesn't show up in tables.
Can anyone guide me what I am doing wrong..