DSUM Formula

  • Thread starter Thread starter Bubba
  • Start date Start date
B

Bubba

I have created a database for Installed Window/Door Sales. The database is
based on one main form where the user enters what product they are selling,
the selects installation options then any other applicable items. The main
form has tabs for each step of the process. The last tab on the form is a
summary page which shows all the selected windows/doors to be installed, and
the pricing from the options they selected. I have a checkbox field that is
called "Include" which is from the main form. This enables to the user to
add and remove items from the sale. I have a total box for the Total Sale
amount, However I am trying to make a total box for only items with
"include" checked off. I cannot get this total to only apply to the current
sale, it Totals all sales in the database. The formula I am currently using
is: =DSum("[T210ExtTotalSellPrice]","[T210]","[T210Include] = 0") Is there
a formula that I could make apply the form rather than the table so that my
formula would not have to be so complicated. Maybe I am looking too deep
into this and there is a very simple formula?
Any help would be appreciated. I know i have not give you field names so
just sample field names would be great.
 
You can use a textbox in the form's footer that has a control source
expression similar to this:

=Abs(Sum(Nz([CheckboxFieldName],0)*Nz([SellPriceFieldName],0)))
 
Back
Top