Dcount Help Me

[amrhi]

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]";"tabletim e";"[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

[MMcCarthy]

ttl=Dcount("[time]";"tabletime";" Minute([time])>15")

[amrhi]

ttl=Dcount("[time]";"tabletime";" Minute([time])>15")

thanks for your help
But the value still not match..
Thank u very much

[MMcCarthy]

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