Access Query

  • Thread starter Thread starter Stressed_fi
  • Start date Start date
S

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?
 
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
 
you can look for my other post help please.

John Spencer MVP said:
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
 
Back
Top