View Single Post
  #3  
Old June 7th, 2010, 06:19 AM posted to microsoft.public.access.queries
BBAL20
external usenet poster
 
Posts: 38
Default Use of Parntheses in Expressions

The following gave me an error saying "You tried to execute a query that does
not include the specified expression"
--
Thank you for your help and support


"KARL DEWEY" wrote:

Try this --
Sum(IIf([Mapping].[Pricing]="CPM",[TPImpressions]/1000*[Mapping].[Price],IIf([Mapping].[Pricing]="CPC",[TPClicks]*[Mapping].[Price],[TPConv]*[Mapping].[Price])))*[Mapping].[Eye Engage Cost]

--
Build a little, test a little.


"bbal20" wrote:

Hello,

I am fairly new to Access and Excel. I am trying to write a
formula/expression, but I think my problem is as simple as having the
parenthese in the wrong place. The formula I have currently is as follows:

Sum(((IIf([Mapping]![Pricing]="CPM",[TPImpressions]/1000*[Mapping]![Price],IIf([Mapping]![Pricing]="CPC",[TPClicks]*[Mapping]![Price],[TPConv]*[Mapping]![Price]))))*[Mapping]![Eye Engage Cost])))))

I basically want the SUM(IF part to be evaluated first and then multiply the
result by [Mapping]![Eye Engage Cost] at the end. Currently, the formula
above returns the value in the Sum(IF, but doesn't mulitply by the Eye Engage
Cost.

Also, can anyone reccomend a website or good reference materail that will
help me understand how parentheses work in Nested Formulas other than knowing
that the innner most parentheses is always evaluated first?
--
Thank you for your help and support