Dcount

  • Thread starter Thread starter TY
  • Start date Start date
T

TY

In my report, I'm using the following formula to count
records: =DCount("[Case
ID+]","sqryAllDataRepList","[Arrival Time] Between #" &
[Forms]![frmSLAReportDialogBox]![BeginningDate] & "# and
#" & [Forms]![frmSLAReportDialogBox]![EndingDate] & "#")
It works fine. But in addition to [Arrival Time], I also
need to filter on [RepLocation]. And I can't get that to
work. For example, I need to count records where
[Arrival Time] is between may and june and where
[RepLocation]=Boston.
 
TY,

Try it like this...
=DCount("*","sqryAllDataRepList","[Arrival Time] Between
[Forms]![frmSLAReportDialogBox]![BeginningDate] And
[Forms]![frmSLAReportDialogBox]![EndingDate] And [RepLocation] =
[Forms]![frmSLAReportDialogBox]![Location]")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DCount 3
Access Dcount (multiple criteria) 3
DCOUNT unique records 2
Dcount question 6
DCount Question 8
Count IIf With AND and OR Criteria 3
DCount within a Group 2
dcount 1

Back
Top