By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,937 Members | 1,532 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,937 IT Pros & Developers. It's quick & easy.

I'm having some issues with math functions in MS Access

P: 4
I'm trying to build a database for all our customers that includes a labor charge, service call charge, parts charge and a grand total. I'm pretty good in math, but to avoid errors, I'd like to make the grand total column automatically compute the sum of the previous three columns. Is this possible, and if so, please explain how to do it, and please, keep in mind that I've never used access in my life.
Jul 23 '10 #1

✓ answered by slenish

Hello again,

Well it would be very long and confusing im sure if i explain how to do this so i just built a simple db for you to learn from. What i did was create a sample table with dummy numbers in it. Im guess that each field would contain money values, based on the types of fields you were using. Next i built a small query that runs a calculating expression to total up the numbers from your table.

you can play with the table and put in any dummy money amounts then save the table. Then all you have to do is open the query and it will calculate it for you.

I hope this helps.

Share this Question
Share on Google+
7 Replies


P: 4
Oh, and I'm using Access 2000
Jul 23 '10 #2

100+
P: 283
Hello,

first off this is possible, but you have to ask yourself a couple of questions. Are you trying to create this input - output to display on a form, print out in a report, show only on a table, or a combination of all the above?

If you can answer these questions it will help us to find a solution for you easier :)
Jul 23 '10 #3

P: 4
Just on the table. It's a very small database, only for repair customers. I actually have not built any reports or forms yet.
Jul 23 '10 #4

100+
P: 283
Hello again,

Well it would be very long and confusing im sure if i explain how to do this so i just built a simple db for you to learn from. What i did was create a sample table with dummy numbers in it. Im guess that each field would contain money values, based on the types of fields you were using. Next i built a small query that runs a calculating expression to total up the numbers from your table.

you can play with the table and put in any dummy money amounts then save the table. Then all you have to do is open the query and it will calculate it for you.

I hope this helps.
Attached Files
File Type: zip TableCal.zip (10.9 KB, 94 views)
Jul 24 '10 #5

P: 4
Thanks, I think that will do the trick
Jul 24 '10 #6

100+
P: 283
Your welcome :)
Jul 24 '10 #7

NeoPa
Expert Mod 15k+
P: 31,769
Nieru,

You really don't want to store this value to your table as that would only be creating a rod for your own back (See Normalisation and Table structures for why).

Instead, simply use a query any time you need it and have the value worked out in the query. Something like :
Expand|Select|Wrap|Line Numbers
  1. TotVal: =[FieldA] + [FieldB] + [FieldC]
Jul 24 '10 #8

Post your reply

Sign in to post your reply or Sign up for a free account.