Error message "System resource exceeded"

J

JenAy

I am getting the message "Sytem resource exceeded". I have no query joins. In
my first query which runs successfully, I have two formulae:

ValueUSD: IIf([Currency]="CAD",[Value]/[USRate
IS-CAD],IIf([Currency]="Euro",[Value]*[USRate
IS-Euro],IIf([Currency]="GBP",[Value]*[USRate IS-GBP],[Value])))

and

ValueC: IIf([Region] Not Like "Europe",IIf([Subtotal 1]="Net
Revenue",[ValueUSD]*-1,[ValueUSD]),[ValueUSD])

Then I have many fields that use ValueC.

This query runs successfully only if I do not add any more columns with
formulae.

If I add additional columns or create another query using the above query
and with no additional columns, I get the above error message.

Can anyone tell me how can get around this?

Thanks,
JenAy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIf expression 3
IF and Vlookup? 3
Calculate report Total where subtotal uses IIf function 2
System Resource Exceeded 2
System Resource Exceeded 5
how do i resolve the 'system resource exceeded' error? 6
System resource exceeded 2
calculated currency field sorts like text instead of numeric 4

Top