sum a field value in all querys

  • Thread starter Thread starter Pedro
  • Start date Start date
P

Pedro

hello everyone
How do i sum a value with another field (always the same one) in all my
querys?
Later, i would like to change that value to see the result in all querys.
How do i do that?
Please explain me best you can do cose i'm not an expert on access.
Tks in advance
Pedro
 
Hi Pedro,

What is the data type of the other field (always the same one)?
The value you wish to sum it with - what data type is it?

For example: if you had a query where one field was called rating and it was
a long integer, if you wanted to add the value 4 to this you could create a
calculated field in the query. We could call the calculated field
ValuePlus4.
In design view of the query, in a new column in the query grid you would
type

ValuePlus4:[Rating]+4.

ValuePlus4 is the name of the field, [Rating]+4 tells Access to take the
value for the field called Rating and add 4 to it.

Now view the query in datasheet view, in the calculated field you should the
value of rating increased by 4 for each row that has a value for rating.

If you wanted to add a different value, you could create a new calculated
field and call it ValuePlusX:[Rating]+X. Replace X with the number you wish
to add to the value.

Jeanette Cunningham
 
Back
Top