multiple query problem

[de049]

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

 

[Rich@ITTC]

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