monthly subtotals and totals

[J.J.]

I know this is simple but I can't seem to be able to do what I would like. I
have a table with contract employees and another table with their dates and
hours worked. I can easily sum all each of their hours in one query and I
can get each of their monthly totals via another. I would like both a montly
subtotal and grand total in one query to more easlily add into a multi-level
report. Thank you

 

[MGFoster]

I know this is simple but I can't seem to be able to do what I would like. I
have a table with contract employees and another table with their dates and
hours worked. I can easily sum all each of their hours in one query and I
can get each of their monthly totals via another. I would like both a montly
subtotal and grand total in one query to more easlily add into a multi-level
report. Thank you

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can't have sub-totals and grand totals in the same query. That's
what reports are for - put the sub-totals and grand total in the report.
Use Section Footers for the sub-totals and the Report Footer for the
grand total.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSZDWSIechKqOuFEgEQIB7QCg7TGaihJcGnLkMiz7L0xQKIPp1VIAn1/q
AZuosc30wHtsBcJlGoNjhLHX
=GapC
-----END PGP SIGNATURE-----

 

[J.J.]

Thank you, very much appreciated. That would explain why I couldn't get it
to work.