Calculate 24 hour count

[Kelly]

Hi,
I have a database that I need to count the parts made for that full day of
production. I do have a percentage time for jobs completed active on the
form, but I need also have the count of current pieces produced in since the
past midnight.

Can I do this in a query expression?

Thanks!
Kelly

 

[Tom van Stiphout]

On Tue, 12 Aug 2008 17:10:40 -0700, Kelly

You could create a totals query, something like:
select count(*)
from SomeTable
where FinishDateTime between DateAdd("d",-1,Date()) and Date()

Or you could create a similar expression using the DCount function.

-Tom.
Microsoft Access MVP

 

[Kelly]

Tom, Thank you - I'll give it a try

On Tue, 12 Aug 2008 17:10:40 -0700, Kelly

You could create a totals query, something like:
select count(*)
from SomeTable
where FinishDateTime between DateAdd("d",-1,Date()) and Date()

Or you could create a similar expression using the DCount function.

-Tom.
Microsoft Access MVP

 

[Kelly]

I was able to get it using Between in the query.

Thanks,