sum a field value in all querys

[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

 

[Jeanette Cunningham]

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