calculation expression

C

cacacaconnie

I am trying to write an expression the will give the sum of a column.
example: I have a quote sheet and I want the sum of the "Item Cost" for all
items. Thanks for your help.
 
A

Al Campagna

cacacaconnie,
Is this a form, or a query, or a report? I'll assume a continuous form, and the
calculated field will be in the form footer...

To sum a non-calculated "bound" control in the form footer...
= Sum([Item Cost])
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
A

Al Campagna

cacacaconnie,
I notice you didn't reply to Fred G or I on your "Force Upper Case" post on 4/18...
How's that going?
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 

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

Resource Budget Cost - Tracking 0
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
Multiple IF Statement in Word 5
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Tweaking a calculated field in a query 4
Compile error in table level validation expression in ms access office 2019 0
Getting the Vertical SUM of a (Custom-Calculated) Duration Field?? 0

Top