Re: event builder

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

--
Duane Hookom
MS Access MVP
--

"FuelMan" <FuelMan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4C4DE20C-B69E-455F-94D2-33358BE0A458@xxxxxxxxxxxxxxxx
>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.


.

Relevant Pages

  • Re: Dealing with NULL values - NZ function
    ... MS Access MVP ... "Joe Williams" wrote in message ... then the value for that total field is NULL. ... > I tried dealing with this in the second query by creating an alias of the ...
    (microsoft.public.access.queries)
  • Re: #Error in the TOTAL Field when no records are present
    ... Duane Hookom ... MS Access MVP ... > I've create a simple record based to a query with a Total Field to ... > date no records are present, the value of my TOTAL field is "#Error". ...
    (microsoft.public.access.reports)
  • Re: Help with Totals in a Report
    ... Try this expression in a group or report footer section: ... Duane Hookom ... MS Access MVP ... > I have the Total field to show the sum for all the total fields? ...
    (microsoft.public.access.reports)
Loading