G
Guest
I have this 'IIF' funtion in an Access query that seems to be running okay;
but the value it is returning is not all correct. Here is my 'IIF' statement:
SameDay Availability: IIf([15 Min Same Day]>="3","Available","Not Available")
The data is imported through a text file with contains the number of
available 15-min slots for each day (time is not used in this database).
What the query should be doing is returning the value "Available" if the
value in the [15 Min Same Day] field is greater than or equal to "3";
otherwise, return "Not Available". It is doing this for some, but in some
instance it is returning "Available" where it should return "Not Available",
and returning "Not Available" where it should return "Available".
Can anyone help???? Thanks!
but the value it is returning is not all correct. Here is my 'IIF' statement:
SameDay Availability: IIf([15 Min Same Day]>="3","Available","Not Available")
The data is imported through a text file with contains the number of
available 15-min slots for each day (time is not used in this database).
What the query should be doing is returning the value "Available" if the
value in the [15 Min Same Day] field is greater than or equal to "3";
otherwise, return "Not Available". It is doing this for some, but in some
instance it is returning "Available" where it should return "Not Available",
and returning "Not Available" where it should return "Available".
Can anyone help???? Thanks!