Return Query values based on calculated field

  • Thread starter Ayse via AccessMonster.com
  • Start date
A

Ayse via AccessMonster.com

I have a query with multiple calculated fields. I need to return a value
of 0 if [RichCalc2a] = 5774 otherwise I want it to display the field value.

I have tried the following statement
IIf([RichCalc2a]=5710,0,[RichCalc2a])
but two parameter windows popup asking for RichCalc2 and RichCalc2A.

Any help would be great!
 
J

Jeff Boyce

Just an observation...

"5710" <> "5774"

Where is the RichCalc and RichCalcA (?a?) located? It may be that you need
to build a query on the query that does that calculation?

Can you provide the SQL statement of that query?
 

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 Statement to return multiple values for a field - JohnW 3
Query Field Using Other Fields in the Query 3
dynamic calculated field in query 3
Complicated Calculated Field Logic 0
Calculated Field in Not Recognized in Function 6
Split data in field on character return 0
referencing Calculated fields in Subqueries.. 2
Prompting for a parameter in a query when one isnt present 2

Top