Hi,

I have a query that contains expressions which sums the number of times a particular value is present in a table. I have this same query repeated four times (once per week) each having the same expressions and carrying out the same calculations. These calculations are: Worked, Absent,etc

I now need a new query that adds the WORKED expresion of all four weeks and displays it as an overall total.

Thankx, 'd

Hi de049

If you want the value over four weeks why not have a query that searches through a period of four weeks (not one week at a time) - eg

Between #03/09/01# And #28/09/01#
(using UK dates - dd/mm/yy) or ...

>=[StartDate] And <=[EndDate]
(as a Parameter query ... this could also call on values given in a form ...

>=Forms!frmMyForm![StartDate] And <=Forms!frmMyForm![EndDate]

HTH

Rich Gorvin