Calculated field, sum/avg results of qry?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to calculate a field in query which uses two values in two fields
(field1, field2) to run a query, then sum and average all the values in two
other fields (field3, field4) in the resulting query, then display that
average in the calculated field. How can I do that?

I would appreciate any help you can give.

Thanks,
Richard
 
Use a totals query with a calculated column that uses two values in two
fields and then sum and average all the values in the other fields. If you
need more help, consider providing some actual table and field names, sample
records, and desired results.
 
Sorry, but I too, cannot get a calculated field to work in Access 2007, in
either queries or in reports. I think maybe a bad bug? If anyone can get it
to work, let us know what you did.
 
This works in Access 2007 Beta, with quite a few sample calculations:-

SELECT Sum(Table1.qty) AS SumOfqty, Sum(Table1.salary) AS SumOfsalary,
Avg([qty]+[salary]) AS xx, Sum([salary]/[qty]) AS yy, Avg([salary]*[qty]) AS
zz
FROM Table1;

Perhaps you could show us your SQL that "doesn't work", and explain how it
"doesn't work".
 
Back
Top