Help with IIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am tyring to get:
If July data is zero, enter August data, if August data is is greater than o
then do august data - july data ,otherwise august data + july data. I have
entered the below but it asks me for parameter values. Can anyone help?

Hours:
IIF(ISNULL([JULYYTD]![TIME_DURATION]),[AUGUSTYTD]![TIME_DURATION],IIF([AUGUSTYTD]![TIME_DURATION]>0,(([AUGUSTYTD]![TIME_DURATION]-[JULYYTD]![TIME_DURATION])),([AUGUSTYTD]![TIME_DURATION]+[JULYYTD]![TIME_DURATION])))
 
You did not say what "parameter values" it ask for.

You do realize that null is not the same as zero. Zero is an actual value
whereas null is the absence of any data.
 

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

dynamically change fields in query 3
Formula to pick up on future data when table is updated 3
IIf Query assistance 7
Drop down box changing my table entries!!! 5
vlookup or dget with multiple condition - help please 4
Sumif/Sumproduct Help 5
Replacing the formula text's substring 2
Create a status designation from 5 date fields using "Not IsNull" 10

Back
Top