Counting

W

williamr

I have a table with a field called 'memodates'. I'm trying to count them by
decade to see how many are 10 years old, 20 years old, etc. My control
source is: =DCount("[memodate]","tbl-bond","(datediff,y,now,memodate)") but I
get an error. Can someone offer help!!!!

Thanks
William
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting 4
Counting 1
Counting yearly totals 5
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Synchronization problems while moving folders to new email 1
DCount in subform syntax question 0
Conditional count on subform 2
Student count for Class Registration 1

Top