Sum Query

  • Thread starter Thread starter sarah
  • Start date Start date
S

sarah

I have a query that creates a new field Total:[Course Cost]
*[Location capacity]

I also want to then be able to SUM this field to obtain an
overall total. At the moment I am achieving this by doing
a seperate query based on the query containing the Total
field and applying the SUM function, is there anyway of
combining this into 1 query?
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Total: Sum([Course Cost] * [Location Capacity])

You'll have to GROUP the query to use an aggregate function (Sum()).
This may cause you further problems. If these problems occur post the
SQL of your query for further help.

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQEz3soechKqOuFEgEQLS8gCg3p/2L7UMSpZ7qcZBuHdpzy7QSlIAoIYa
jndibX7fewZzJGbh7xnYgEsc
=yIve
-----END PGP SIGNATURE-----
 
Back
Top