event builder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a database for quoting equipment. I have started with a very
small test using a table with a drop down of equipment model numbers and then
a QTY,PRICE, and TOTAL field. I created a form and using expression builder
want to multiply the QTY*Price and populate the Total field. I have the
following expression, but it does not work.

=[Qty Needed]*[Price]=[Total]

any help would be appreciated I am a novice with this aspect of Access.
 
That worked after I realized that the control source needed to be done at the
table level not on the form. It appears to be same expression I tried a
couple of times in the form design. At least I think that is how it is
working.

Thanks

Duane Hookom said:
Try a control source of:
=[Qty Needed]*[Price]

--
Duane Hookom
MS Access MVP
--

FuelMan said:
I am working on a database for quoting equipment. I have started with a
very
small test using a table with a drop down of equipment model numbers and
then
a QTY,PRICE, and TOTAL field. I created a form and using expression
builder
want to multiply the QTY*Price and populate the Total field. I have the
following expression, but it does not work.

=[Qty Needed]*[Price]=[Total]

any help would be appreciated I am a novice with this aspect of Access.
Click to expand...
Click to expand...
 
Back
Top