Aggregate Query in Access 2007

  • Thread starter Thread starter R Tanner
  • Start date Start date
R

R Tanner

Hi,

I'm trying to create a simple query to come up with the difference
between two numbers. In the following expression, Limit is a value of
'Number' type in a table and for the sum I am just summing the values
in a table. How can I do this? It keeps telling me 'Cannot have
aggregate function in expression'. I have this query set to a total's
query. Any ideas?


"Pips Available": ([Employee_List]![Limit]-Sum([Transactions].
[Amount]))

By the way, does anyone know why Access differs so much from SQL
Server?? It kind of sucks honestly.
 
Hi,

I'm trying to create a simple query to come up with the difference
between two numbers. In the following expression, Limit is a value of
'Number' type in a table and for the sum I am just summing the values
in a table.  How can I do this?  It keeps telling me 'Cannot have
aggregate function in expression'.  I have this query set to a total's
query.  Any ideas?

"Pips Available": ([Employee_List]![Limit]-Sum([Transactions].
[Amount]))

By the way, does anyone know why Access differs so much from SQL
Server??  It kind of sucks honestly.
Click to expand...

Nevermind, I solved my problem.

"Pips Available": SUM([Employee_List]!Limit) - SUM([Transactions].
[Amount])
 
Back
Top