Recent content by Zc kaiva

  1. Zc kaiva

    Using textbox value for DCount() #Error

    =Dcount("[BusNo]","qryBus","[RegDate]=#" & Format$([Text1], "mm\/dd\/yyyy") & "#") I tried it but it keeps givim 0 as count.
  2. Zc kaiva

    Using textbox value for DCount() #Error

    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?
  3. Zc kaiva

    Enter date criteria only once for Report and subReport.

    I used filter on load on report and it worked ok.
  4. Zc kaiva

    Enter date criteria only once for Report and subReport.

    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?
  5. Zc kaiva

    DCount problem, count including blank

    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)
  6. Zc kaiva

    DCount problem, count including blank

    I changed "" to Null and now its working fine. Thank you.
  7. Zc kaiva

    DCount problem, count including blank

    Thank you, this helped.
  8. Zc kaiva

    DCount problem, count including blank

    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?
  9. Zc kaiva

    Hello all,

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