Field mathmatics - Access TechHelp - Computer Learning Zone


	Back to Access TechHelp Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Field mathmatics

Richard Van Wagoner

4 years ago

I am trying to build a database for my small company, I have been taking your classes and I am at expert 7. I am trying to figure out how to combine numbers in two fields in one form, For example, two parts make a complete component. Each has an ID Number, Description, and Price. When I use a combo box to bring these items to my form It displays fine. But adding them only adds Their ID numbers. Is there somewhere to go to see this in more detail? Is it in a future lesson? Thanks

	Kevin Robertson @Reply 4 years ago
What are you trying to add up? Can you give an example?

	Kevin Yip @Reply 4 years ago
Maybe Richard wants to concatenate the data. Look up Richard's videos on concatenation. Mathematics: 20 + 22 equals 42 Concatenation: "20" & "22" equals "2022"

	Richard Van Wagoner OP @Reply 4 years ago
Here is a picture of my form. I want to add blank and kit fields.

	Richard Van Wagoner OP @Reply 4 years ago

	Kevin Robertson @Reply 4 years ago
Assuming each Combo Box has 3 columns, and the price is in the third column you can put something similar to the following in the Control Source of the TotalPrice Textbox. `=CCur(Nz([cboBlank].[Column](2)))+CCur(Nz([cboKit].[Column](2)))`

	Kevin Robertson @Reply 4 years ago

	Richard Van Wagoner OP @Reply 4 years ago

	Richard Van Wagoner OP @Reply 4 years ago
Does this work if my currency field is in the second column? My auto field is in the number1 column.

	Kevin Robertson @Reply 4 years ago
Yes. Just change the 2 to a 1 (columns are zero-based).

	Richard Van Wagoner OP @Reply 4 years ago
I did that and I am getting this #Name?. Did I miss something?

	Richard Van Wagoner OP @Reply 4 years ago

	Kevin Robertson @Reply 4 years ago
cboBlank and cboKit is what I called the Combo Boxes in my example. Change them to whatever you have named yours.

	Richard Van Wagoner OP @Reply 4 years ago
I have solved the #Name? problem. Thanks! Just for my information if there are more than 2 fields to add what is needed to change in the Control Source to add them?

	Adam Schwanz @Reply 4 years ago
You can add as many fields together as you want, when you use + you are doing a mathematical calculation, when you use & you are using concatenation If Field1 Field2 and Field3 were 10 =Field1+Field2+Field3 would be 30 =Field1 & Field2 & Field3 would be 101010

	Richard Van Wagoner OP @Reply 4 years ago
I noticed that it isn't storing this in my product table, Is there something else needed to make this happen?

	Adam Schwanz @Reply 4 years ago
Your control source needs to be set to a field if you want the text box to connect. Right now its just an unbound field with your calculation. Youll need to make a button or some kind of event like After Update To set the value of that field to your calculation instead Fieldname=a+b kind of thing

	Richard Van Wagoner OP @Reply 4 years ago
Thanks Adam. But I think I am getting way over my head here. I think I will wait for a few more lessons before I attempt this.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access TechHelp.

Next Unseen

New Feature: Comment Live View