query to sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Duplicates in Query 0
SUM in a UNION query 2
running total of records in query 1
Interesting HR Database - Queries 15
sql query needed urgent 4
minimize repeating query criteria & generating monthly YTD totals 1
Counting with multiple criteria 3
Running Sum in query 1

Back
Top