Formatting Dcount

[hotplate]

On an after update I am using:

[NCMT] = (Format(Date, "ddmmyy") & DCount("*", "[tblNCMT_Log]",
"[NCMT_Date] = #" & Date & "#"))

How do I get format the result so it is "05010901" instead of
"0501091"?

Also, how do I get it to start counting at from 1 not 0 so my first
record for the day wont be "05010900".

Thanks,

Garrett

 

[Albert D. Kallal]

DCount("*", "[tblNCMT_Log]","[NCMT_Date] = #" & Date & "#")


Simply wrap the above in a format command:

format(above,"00")

Also, how do I get it to start counting at from 1 not 0 so my first
record for the day wont be "05010900".

Just add + 1 BEFORE your format:

eg:

format(above + 1,"00")