hi
am trying to use the IIF function in my database.
i have a column called interval(just wondering if my way of writing this is wrong. as this column contains a date and a time. If i write the time only will it pick it up in the query). what i want to do is say that if the value in this column is > 23:00:00 then use a night figure and if not use a day figure.Import is the table i am using.
eg
iif(Import.interval>23:00:00, Import.DayFigure * 3, Import.NightFigure*3)
Is my syntax completely wrong here.
thanks a million in advance for your help.
kindest regards
lasd
am trying to use the IIF function in my database.
i have a column called interval(just wondering if my way of writing this is wrong. as this column contains a date and a time. If i write the time only will it pick it up in the query). what i want to do is say that if the value in this column is > 23:00:00 then use a night figure and if not use a day figure.Import is the table i am using.
eg
iif(Import.interval>23:00:00, Import.DayFigure * 3, Import.NightFigure*3)
Is my syntax completely wrong here.
thanks a million in advance for your help.
kindest regards
lasd