Solved Dcount with 2 criteria.

[theinviter]

Dear guys;
need help,
i have a form to count the number in record by 2 criteria.
i tried this but not work,

Me.Text186 = Nz(DCount("*", "[MRN]", "[Location - Clinics Name] ='" & Me.Combo2 & "'" & "Date_ BETWEEN DateValue('" & Me.From & "') AND DateValue('" & Me.to_ & "') ), 0)

so what to do.

 

[theDBguy]

Try breaking it down. Can you make it work if you only have one criteria?

 

[theinviter]

tried tis but still got syntax error
Text17 = Nz(DCount("*", "[MRN]", "[Date_] between #" & [Dates_From] & "# _And #" & [Dates_To] & "#"), 0)

 

[bob fitz]

Text17 = Nz(DCount("*", "[MRN]", "[Date_] between #" & [Dates_From] & "# _And #" & [Dates_To] & "#"), 0)
Perhaps that should be
Text17 = Nz(DCount("*", "[MRN]", "[Date_] between #" & [Dates_From] & "# And #" & [Dates_To] & "#"), 0)

 

[theinviter]

Text17 = Nz(DCount("*", "[MRN]", "[Date_] between #" & [Dates_From] & "# _And #" & [Dates_To] & "#"), 0)
Perhaps that should be
Text17 = Nz(DCount("*", "[MRN]", "[Date_] between #" & [Dates_From] & "# And #" & [Dates_To] & "#"), 0)

thanks alot
but how to add the second criteria [Location - Clinics Name]