Set default value as blank for calculated field

[Gareth Jones]

Hi,

Can anyone think of a way around this please?

If the field [total mins] is blank (because the task hasnt finished yet) It sets the field as NO.

IIf(([total mins]<=1440) And ([priority]=3),"YES","NO")

Ideally I want the field to remain blank until the end time is entered, giving me the [total mins] Then if its less than 1440 it will return YES, if its more, it will return NO. Apart from this, it works fine.

I have tried all day with this one and searched and searched but cannot seem to crack it.

Thanks all in advance

Gareth

[TheSmileyCoder]

I suspect a nested IIF should suffice for your needs.

IIF(Isnull([Total Mins),"",IIf(([total mins]<=1440) And ([priority]=3),"YES","NO"))

[Gareth Jones]

This works perfectly. Thank you very much.