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.
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?
Hi all, i want to count all records inside AmBus column inside query qryBusCountName excluding blanks (" " )
But DCount is counting blank fields as well.
How can i exlcude blanks in my count?