trouble multiplying

[gayle.fisher]

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.

 

[Bob Howard]

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