A
Adam Thwaites
The following code is supposed to count how many calls an agent has logged on
this particular day, but it is returning the total number of calls made ever.
Can anyone see a problem with the date part?
lblCalls.Caption = DCount("*", "tbl_Main", "[AgentName]=""" &
[Forms]![frm_CallLogger]![txtAgentName] & """ And """ & "[SaveDate]=
DateValue(now)""")
Also I also want to build the date filter on this DCount but I can't get it
to work:
lblUpsells.Caption = DCount("*", "tbl_Main", "[AgentName]=""" &
[Forms]![frm_CallLogger]![txtAgentName] & """ And " & "[OutcomeFlush]=" &
"true" And """ & "[SaveDate]= DateValue(now)""")
Thanks for any help you can offer!
this particular day, but it is returning the total number of calls made ever.
Can anyone see a problem with the date part?
lblCalls.Caption = DCount("*", "tbl_Main", "[AgentName]=""" &
[Forms]![frm_CallLogger]![txtAgentName] & """ And """ & "[SaveDate]=
DateValue(now)""")
Also I also want to build the date filter on this DCount but I can't get it
to work:
lblUpsells.Caption = DCount("*", "tbl_Main", "[AgentName]=""" &
[Forms]![frm_CallLogger]![txtAgentName] & """ And " & "[OutcomeFlush]=" &
"true" And """ & "[SaveDate]= DateValue(now)""")
Thanks for any help you can offer!