Is it possible to get a sum in one field in my query if the result in - Microsoft Community

table 1: special orders

     fields: order number

                apply admin fee (this 1 yes/no)

table 2: special order details

     fields: item cost

                quantity

                extended item cost (multiplies item cost quantity)

query:

      field: expected revenue - if apply admin fee = yes, return sum of extended item cost - 8% (this works following  -                      expectedrevenue: sum(iif([special orders].[apply admin fee]=yes,[extended menu item cost]-([extended menu item                                    cost]*0.08),null))

                                                if apply admin fee = no, return sum of extended item cost - cannot figure out how                          second summing expression added original summing expression.

thanks help!

query:

      field: expected revenue - if apply admin fee = yes, return sum of extended item cost - 8% (this works following  -                      expectedrevenue: sum(iif([special orders].[apply admin fee]=yes,[extended menu item cost]-([extended menu item                                    cost]*0.08),null))

                                                if apply admin fee = no, return sum of extended item cost - cannot figure out how the                          second summing expression added original summing expression.

the short answer 'yes.'

this sounds whole lot homework assignment.  in above put underline in copy of post nobody puts many spaces within field name or other entries.   makes me assume text copied without editing website class study assignment!

Office / Access / Other/unknown / Office 2013