Zc kaiva
New member
- Local time
- Today, 07:27
- Joined
- May 9, 2021
- Messages
- 9
I have a textbox 'Text1' which stores date value entered as report parameter on my report. When u use it with dcount() as criteria it gives me #error. This is what i have.
=Nz(Dcount("[BusNo]","[qryBus]","[qryBus].[RegDate]=[Text1]"),0)
Can anyone help me find my mistake?
=Nz(Dcount("[BusNo]","[qryBus]","[qryBus].[RegDate]=[Text1]"),0)
Can anyone help me find my mistake?