Is there a way to convert the date and time value returned by the Now() function into a whole number. I am attempting to group scans by a unique number. When the users clicks a "Save" button, I would like to save that unique number to a table. Each scan will be one record stored in a recordset until the user clicks Save. All of the records created in a recordset would have the unique number as a field. I want to include time to make sure the number is unique.
Another alternative would be to save a unique number to a table and read it each time the form is loaded. It would then be incremented each time the scans are saved.
I would like to see how the first option works before I decide. Does anyone have any suggestions?
Thank you.
Another alternative would be to save a unique number to a table and read it each time the form is loaded. It would then be incremented each time the scans are saved.
I would like to see how the first option works before I decide. Does anyone have any suggestions?
Thank you.