Hi all,
should be a quick one, but its being a bit of a pain.
I have a field that is number format showing a duration. There are some in this field that contain decimals, which are always halves, ie. .5 but the whole number can be anything (I have 14.5, 7.5, 20.5 etc.)
using this iif I can classify the 0.5's:
Partial Days: IIf([Duration_Days]=.5,"Partial Days, cha!","")
But i cant seem to find a wildcard that works. # just gives me an error.
Anyone with any tips?
should be a quick one, but its being a bit of a pain.
I have a field that is number format showing a duration. There are some in this field that contain decimals, which are always halves, ie. .5 but the whole number can be anything (I have 14.5, 7.5, 20.5 etc.)
using this iif I can classify the 0.5's:
Partial Days: IIf([Duration_Days]=.5,"Partial Days, cha!","")
But i cant seem to find a wildcard that works. # just gives me an error.
Anyone with any tips?