Query...

[116]

I am looking for a count of items meeting certain criteria. I am using this
< Between DLookUp("[Date]","t_Heat_Treat_Oven_Log","[PC]='THERM'") And Date()

to retrieve the data, but have been unable to get a count. I had to put

the above in a sub query, and create one just for the count. Is there a way
to do this in one query?

Thanks
David

 

[Tom Willett]

If this is an Excel question, you need to post in an Excel newsgroup, not
Frontpage.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage Since 1997
---------------------------
:I am looking for a count of items meeting certain criteria. I am using
this
: < Between DLookUp("[Date]","t_Heat_Treat_Oven_Log","[PC]='THERM'") And
Date()
: > to retrieve the data, but have been unable to get a count. I had to put
: the above in a sub query, and create one just for the count. Is there a
way
: to do this in one query?
:
: Thanks
: David

 

[116]

Sorry all. I posted to the wrong group.

David

I am looking for a count of items meeting certain criteria. I am using this
< Between DLookUp("[Date]","t_Heat_Treat_Oven_Log","[PC]='THERM'") And Date()

to retrieve the data, but have been unable to get a count. I had to put

the above in a sub query, and create one just for the count. Is there a way
to do this in one query?

Thanks
David