Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am tring to format a field so it will autonumber, but I need the first to
digets to be the month and the next 6 digets to start at 1 and count up by
one. I format like that but can't figure out hoe to make it autochange the
first 2 digets every month so it with look like this

10000001 11000006
10000002 11000007
10000003 12000008
11000004
11000005

Can someone please help me. If so please email me at
(e-mail address removed). Thanks
 
Mustangric said:
I am tring to format a field so it will autonumber, but I need the first to
digets to be the month and the next 6 digets to start at 1 and count up by
one. I format like that but can't figure out hoe to make it autochange the
first 2 digets every month so it with look like this

10000001 11000006
10000002 11000007
10000003 12000008
11000004
11000005

Can someone please help me. If so please email me at
(e-mail address removed). Thanks
Click to expand...


No private emails. Newsgroups are for the publc benefit

The "right" way to deal with this is to have two fields, one
for the full date and the other for the sequential number.
Makes life a lot easier.

Then you can format them whenever you need to display the
combined value:
=Format(datefield,"mm") & Format(numberfield, "000000")
 
Back
Top