M
Mike
I have created a sequencing number based off of the
calender. Essentially it is to obtain a new number with
the following format: yymmdd-##. The ## is the problem. I
can't figure a way to crete the two digit number, ex: 01,
02, 03..etc. Also I can't figure out how to reset it when
the day changes to a new number can be started, like when
it reaches 12:00:00 a.m.
For example: Today would be 031224-01, -02, etc.
But tomorrow would be 031225-01, -02, etc.
This is for an operator to add a number to the table and
base a many to one relationship off of this number-->
basically for one of these numbers, there will be at most
12 records undneath this guy.
here is the code I've been playing with:
Me.Heat = Right("00" & Year(Date), 2) & Right("00" & Month
(Date), 2) & Right("00" & Day(Date), 2) & "-" & Right("00"
& mycounter + 1, 2)
Thanks.
calender. Essentially it is to obtain a new number with
the following format: yymmdd-##. The ## is the problem. I
can't figure a way to crete the two digit number, ex: 01,
02, 03..etc. Also I can't figure out how to reset it when
the day changes to a new number can be started, like when
it reaches 12:00:00 a.m.
For example: Today would be 031224-01, -02, etc.
But tomorrow would be 031225-01, -02, etc.
This is for an operator to add a number to the table and
base a many to one relationship off of this number-->
basically for one of these numbers, there will be at most
12 records undneath this guy.
here is the code I've been playing with:
Me.Heat = Right("00" & Year(Date), 2) & Right("00" & Month
(Date), 2) & Right("00" & Day(Date), 2) & "-" & Right("00"
& mycounter + 1, 2)
Thanks.