count and recount by per date and by per user.

[valkyry]

Ok, I have the following in my form:
CustomQuoteNumber: Format([EntryDate],"yymmdd") & recordnumber & [EnteredBy]

It's a logic based off of:
1. Entry Date (actual field) in the yymmdd format then by
2. Record number of the day which needs to always begin with 01 each day and by each user. This gives 99 orders per day per user.
3. EnteredBy (actual field), which is the user id

So it would be 060720 (EntryDate) followed by 01 for the 1st order of the day and ending with the AE user's initials (EnteredBy).

the result is 06072001AE

the next order would be 06072002AE
continues until 99.

then the next day would be 06072101AE and 06072101VR and so on.


Ideally it'll restart per change in the user's initials (EnteredBy).

Meaning, if another person enters a quote, the quote for that person is 06072001@@ (@@ for the other user's initials).

Hope this makes sense.

I don't know how to tell it to calculate the 01 through 99 repeating per user and per day.

 

[randy700]

Look at the DLookUp function.

Randy

 

[Remou]

This thread is a continuation of:
Change record number per day to always start over?
thread703-1256971

 

[valkyry]

DLookUp what?

NOTE: from the Report Thread I was able to get help with using a control = "01" for the two digit.

but can't get it to count.
so all my records are always 01

06072001AE for the 1st record
06072001AE for the 2nd record

i need the second record to be 06072002AE

yymmdd(recordcount)initials

another record would be
06072001VR
06072002VR

if another user creates quotes on the same day.

it's a record counter that reset for each day and each user is what I need.

HELP!