Access Query

[Stressed_fi]

I have to make a query, which has to make a calculation. does anyone know how
to do it in a query formatation?

 

[John Spencer MVP]

Well, it depends on what the calculation is. If you need to add two NUMBER
fields that always have a value in the same record it is simply.

Field: MyAddition: Field1 + Field2

You can also do subtraction, division, and addition the same way using the
appropriate operators.

If you want more help than this you need to supply more information on exactly
what the calculation is. Does it involve fields in one record, a field in
multiple records (average, sum, max, min, etc.)?

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Stressed_fi]

you can look for my other post help please.

Well, it depends on what the calculation is. If you need to add two NUMBER
fields that always have a value in the same record it is simply.

Field: MyAddition: Field1 + Field2

You can also do subtraction, division, and addition the same way using the
appropriate operators.

If you want more help than this you need to supply more information on exactly
what the calculation is. Does it involve fields in one record, a field in
multiple records (average, sum, max, min, etc.)?

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County