MS Access Calculated form fileds
Posted on 2011-03-01
I have been living in this forum for a couple of days gaining lost knowledge of MS Access. Apparently not working with he program for many years you forget things...
here is full scenerio:
fields are [number][choice][choicecost][yes][totalcost] and [grouptotal]
I have successfully got a dropdown combo box chose to populate a couple of fields
the choice made in list populates the field [choice] and [choicecost] i have a yes or no check box [yes] that can add $5 if "yes" to the [choicecost] result which I want to be populate in [totalcost]. The I need to multiply [totalcost] by [number] to populate [grouptotal].
first I can't seem to populate the [totalcost] field. I have tried a textbox withe the control source =
"=IIf([yes]=1,([choicecost]+5),[choicecost]) but I get the #Name? error
Iwas going to attempt to popluate that result of the textbox to the [totalcost] field.
I then tried the query option but got no results at all.
Once I get that to work Iwas going to tackle the [grouptotal] calculations.
any help would be great! (keep in mind I have not been using access for many years and my knowledge is much less than i thought.