Query Problem-“You tried to execute a query that does not include

T

The Chad

Hi All,

I am trying to run a query and every time I try I get an error message that
says:
“You tried to execute a query that does not include the specified expression
‘[DR2]![Response]/Max([DR2]![Response]))*([Weights]![MaxWeight]’ as part of
an aggregate functionâ€

I have done some general internet research and referenced the Access books I
have here and still not clarity on what the issue is. Do any of you have any
thoughts?

Thanks,
 
M

MGFoster

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

You have this expression in the SELECT clause:

[DR2]![Response]/Max([DR2]![Response]))*([Weights]![MaxWeight]

It must also be in the GROUP BY clause.


BTW, The connector between a table reference and a column name is a
period not an exclamation mark.

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

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

iQA/AwUBQjetTIechKqOuFEgEQL0ZwCeKQ5IlBesBJ8WSc+ocJeK9XFBnHMAn0pP
meTDcc1NbHNaFRXHuJEF78Qy
=DILZ
-----END PGP SIGNATURE-----
 
Top