By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,959 Members | 1,136 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,959 IT Pros & Developers. It's quick & easy.

Dcount Help Me

P: 22
Hello guys
i want to dcount my record with criteria time ....?
example to count my records only with field that have time more than 15 minutes .
ttl=Dcount("[time]";"tabletime";"[time]>#0:15#")
the result it count all records .
for example i only have 5 records in time field more than 15 minutes....
i want to get only that 5 records
anyone can help me....
thanks
Oct 21 '06 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
ttl=Dcount("[time]";"tabletime";"Minute([time])>15")
Oct 21 '06 #2

P: 22
ttl=Dcount("[time]";"tabletime";"Minute([time])>15")
thanks for your help
But the value still not match..
Thank u very much
Oct 22 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
This should work. What's the format of your time field exactly?



thanks for your help
But the value still not match..
Thank u very much
Oct 22 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.