DCount Recs only for current year

[rjf3123]

Tying to create a form that will count records in tblClientTracking where the year in the SubmitDate field is
only the current year.

This syntax is giving me #error and #headache!

=DCount("[SubmitDate]","[tblClientTracking]","DatePart('yyyy',([SubmitDate]))&quot

Anyone see what's wrong with this?

TIA -
R. Fisher

 

[jdegeorge]

You have the DCount syntax wrong.

Should be something like

=DCount("[SubmitDate]","[tblClientTracking]","DatePart('yyyy',([SubmitDate])) = SOMETHING&quot


Jim DeGeorge

 

[rjf3123]

Thanks tons Jim -

I knew I was on the right track, at least with 3 wheels. I am posting the correct function here for future seekers ...

=DCount("[SubmitDate]","[ClientTracking]","DatePart('yyyy',([SubmitDate])) = DatePart('yyyy',date())&quot

This works great!

R. Fisher

 

[jdegeorge]

Glad to have helped, and yes, the Tek-Tip folks like to see the answers and acknowledgements that it worked. Nice going.

Jim DeGeorge