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?
For eg. Report1-main report
Subreports. SubReport1, SubReport2.
When i open my main report, it asks me to enter criteria( date) 3 times. Is there any way i can enter date criteria only once for all reports?
I changed "" to null in expression below on my query.
AmBus: IIf([BusNo] like "L19*" And [AM/PM]="AM", [BusNo],Null)
And on the my report i used
=Nz(DCount("[AmBus]","[qryBusCountName]"),0)
Hi all, i want to count all records inside AmBus column inside query qryBusCountName excluding blanks (" " )
But DCount is counting blank fields as well.
=Nz(DCount("[AmBus]","[qryBusCountName]"),0)
How can i exlcude blanks in my count?