<div>
Try: 
 
[Price Each USD]: IIf(Left([mc476mth]![plant],2)=&quot;BR&quot;,([mm60]![price]/[Forms].[main]![brl to usd]),IIf(Left([mc476mth]![plant],2)=&quot;CA&quot;,([mm60]![price]/[Forms].[main]![cad to usd]),IIf(IsNull([mc476mth]![plant]),&quot;N/A&quot;))) 
 
The [ and ] is needed for the spaces, better never to use spaces in fieldnames... 
 
Nic;o)
</div>

Try:

[Price Each USD]: IIf(Left([mc476mth]![plant],2)="BR",([mm60]![price]/[Forms].[main]![brl to usd]),IIf(Left([mc476mth]![plant],2)="CA",([mm60]![price]/[Forms].[main]![cad to usd]),IIf(IsNull([mc476mth]![plant]),"N/A")))

The [ and ] is needed for the spaces, better never to use spaces in fieldnames...

Nic;o)

<div>
Can you post the whole SQL Statement? 
 
Thanks, 
Mike 

</div>

Can you post the whole SQL Statement?

Thanks,
Mike


<div>
<div class="content wysiwyg-content">
Heres the query 
 
Price Each USD: IIf(Left([mc476mth]![plant],2)=&quot;BR&quot;,([mm60]![price]/[Forms].[main]![brl to usd]),IIf(Left([mc476mth]![plant],2)=&quot;CA&quot;,([mm60]![price]/[Forms].[main]![cad to usd]),IIf(IsNull([mc476mth]![plant]),&quot;N/A&quot;))) 
 
What's wrong w/ this? &nbsp;Even if I change it to a &quot;GROUP BY&quot; it still gives me the same error.
</div>
</div>

Heres the query

Price Each USD: IIf(Left([mc476mth]![plant],2)="BR",([mm60]![price]/[Forms].[main]![brl to usd]),IIf(Left([mc476mth]![plant],2)="CA",([mm60]![price]/[Forms].[main]![cad to usd]),IIf(IsNull([mc476mth]![plant]),"N/A")))

What's wrong w/ this?  Even if I change it to a "GROUP BY" it still gives me the same error.

You tried to execute a query that doesn't include the specified expression as part of an aggregate function

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.