If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
trouble multiplying
I am new to Access and I am trying to mulitply 2 fields in the same
table. One column is labeled Units and that number varies on each entry. The other column is labled Rate and that number also varies. But I have a column labeled Total and I just want the Unit * Rate to display in the total each time. I just cant figure it out! Please help. |
#2
|
|||
|
|||
trouble multiplying
You cancertainly do that by writing an "update query" where the calculation
is [Total] = [Unit]*[Rate] --- But having said that, your idea violates the basics of a relational database. You may wish to consider only computing [Total] when it's needed on a Form or a Report. Bob wrote in message oups.com... I am new to Access and I am trying to mulitply 2 fields in the same table. One column is labeled Units and that number varies on each entry. The other column is labled Rate and that number also varies. But I have a column labeled Total and I just want the Unit * Rate to display in the total each time. I just cant figure it out! Please help. |
Thread Tools | |
Display Modes | |
|
|