theinviter
Registered User.
- Local time
- Today, 01:24
- Joined
- Aug 14, 2014
- Messages
- 237
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.
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.