sweetelka18
Technical User
I am trying to create a and 8 digit number that
always begins with a 46 contains a Juliandate and then the order seen that day. I would like for it to print out in the reports and in one of the fields in a subform. Usually it is written when a person visits so it would need to restart numbering everyday. The database shows the patient data in a form and in the subform is listed the information visit so each visit is saved and a new record is created everytime but the persons data stays the same.
The number would look like this for
46001001
the first 2 digits is static it does not change
the next 3 digits changes according to Julian Date
the last 3 digits is order in which person comes in.
The reports reflects this number, the person seen, visit details printed out for entire day. ie list of persons seen that day per this number.
Please help!!!
always begins with a 46 contains a Juliandate and then the order seen that day. I would like for it to print out in the reports and in one of the fields in a subform. Usually it is written when a person visits so it would need to restart numbering everyday. The database shows the patient data in a form and in the subform is listed the information visit so each visit is saved and a new record is created everytime but the persons data stays the same.
The number would look like this for
46001001
the first 2 digits is static it does not change
the next 3 digits changes according to Julian Date
the last 3 digits is order in which person comes in.
The reports reflects this number, the person seen, visit details printed out for entire day. ie list of persons seen that day per this number.
Please help!!!