Search results

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?

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?

Am a programming starter, and access is pretty new to me.