Count Vs Dcount

[SWG]

"Count" and "Dcount" giving me different output, i was counting the number of Submission Date >= April 01-2011 , Below are the Expression that i wrote & the output i got........



By Using Count:
Expression: =Count(IIf([qrySWGOverall]![Submission Date]>=#01/04/2011#,1))

Output: Total Number of Submission 2011/2012: 22

By Using Dcount:
Expression: =DCount("[Submission Date]","qrySWGOverall","[Submission Date]>=#01/04/2011#")

Output: Total Number of Submission 2011/2012: 24

***** Count Expression giving me correct number***** Any suggestions would help.... Thanks for your time.

[Jester0001]

Access Help (for 2010) says that the Count() function is

optimized to speed counting of records in queries. Use the Count function in a query expression instead of the DCount function, and set optional criteria to enforce any restrictions on the results. Use the DCount function when you must count records in a domain from within a code module or macro, or in a calculated control.

From your fomulas, I'm guessing that you are trying to count the records from a query [qrySWGOverall]. If this is correct, and if you get the correct answer by using the Count() function, then why not just go with the Count() function? Or am I missing something?