Counter on a Form

[athyeh]

Hello,

I am posting that under several Headings because I am not sure where the answer lies (Query, VBA, somewhere else), but basically I have a form with headings:

LID: (Acct #)
Operator: (Data-Entry Processor)
Time: (7:00 AM - 8:00 AM, 8:00 AM - 9:00 AM, etc)
Process: (Packaging, Shipping, etc)
Primary: Descritpion of shift
Secondary: Descritpion of shift
Secondary: Descritpion of shift



The form is designed to allow users to use a wand to quickly scan in multiple LID's under the other field options.

The form is tied to a table, "MainDB" that records all this information.

How can I create a counter on the Form that counts how many LID's that specific Operator is doing (this form will be distributed to 50+ front-end users, and I don't want them knowing what everyone else is doing)

Thank you for your replies.

[pbaldy]

Hello,

I am posting that under several Headings because I am not sure where the answer lies (Query, VBA, somewhere else), but basically I have a form with headings:

Please don't post the same question multiple times.

[pbaldy]

One way would be a DCount() function with the operator as a criteria.

[athyeh]

Thank you for your reply, and I will not do that again.

=DCount("[LID]","tblMainDB","Operator" And "Time")

Produces a count for all records, regardless of Operator or Time... How can I edit?

Also tried:

=DCount("[LID]","tblMainDB","[me]![Operator]" And "[me]![Time]")

[pbaldy]

See if this helps:

DLookup Usage Samples

[athyeh]

=DCount("LID","tblMainDB","LID = " & [Forms]![frmMAINFORM]![Operator] & " AND [Forms]![frmMAINFORM]![Time]")

Please assist...

[pbaldy]

You don't have the second field name. If both are numeric fields:

=DCount("LID","tblMainDB","LID = " & [Forms]![frmMAINFORM]![Operator] & " AND [Time] = " & [Forms]![frmMAINFORM]![Time])

Time isn't a good field name, as Access can confuse it with the built-in Time() function.

[athyeh]

Perfect. Thread Solved. Thank you.

[pbaldy]

No problem.

[athyeh]

Unsolved.... How do I incorporate reset options (Per Day, Per Hour)? Is there anyway to automate those options?