query to sum

P

Pam Coleman

If I want to run a query that will search all records and when it finds a 5
or more it will add 10 and give me the total, and if it is less than 5 it
will not make changes.
Thanks,
 
D

Duane Hookom

Your subject suggests you want to "sum" which implies totalling across
records. The body of your message doesn't include anything about totaling or
summing across records.

To create a column in a query as you ask, use an expression like:
NewFieldA: IIf([FieldA]>=5, [FieldA] + 10, [FieldA])

I am not sure if this comes close to answering your question. If not,
consider providing sample records and desired output.
 
Top