Total Query

[ccordner]

Hi.

I'm trying to write a query to count the number of "Rest Days" worked in the current period. I have built the query below (actually, it was much more complicated until I realised it wasn't working) and it will count the rest days for each cost centre, but it includes all the rest days worked, not just the ones for the current period.

Is it something I've missed, or do I have to do it as two separate queries?

Thanks
Chris

[June7]

What is current period - this week, month, quarter? Need filter criteria.

BTW, not a good idea to use special characters and punctuation (underscore is exception) in names. Better would be: TargetRestDays or Target_RestDays

[ccordner]

Thanks

Periods are stored in a table, tblPeriods, with the Start and End date for each. Normally they are four weeks except at the beginning and end of the year (sometimes) so the last one finishes at the end of March.

qryCurrentPeriod retrieves the period where today is greater than (or equal to) the start date and less than (or equal to) the end date. I have a similar query, qryLastPeriod too.

I'm slowly changing some of the field names, but things in other programs depend on them, so I'm being a bit careful not to 'break' anything!

Thanks
Chris

[June7]

Did you try adding criteria to the query design?