expression with True of False showing up as -1 or 0

[Agent_KGB]

I have a simple expression (Contract Date > Date()) but i woul dlike to see
result as TRUE / FALSE or YES/NO however in my query it shows up as -1 or
0... how can i fix it?

 

[Klatuu]

In Your Query builder, use a calculated field:

SomeDate: IIf([Contract Date] > Date()), "YES", "NO")

in SQL it would be
SELECT IIf([Contract Date] > Date()), "YES", "NO") AS SomeDate .....

 

[Agent_KGB]

Tried that (query Builder)... keep getting an error message saying that my
expression has a wrong number of arguments

In Your Query builder, use a calculated field:

SomeDate: IIf([Contract Date] > Date()), "YES", "NO")

in SQL it would be
SELECT IIf([Contract Date] > Date()), "YES", "NO") AS SomeDate .....
--
Dave Hargis, Microsoft Access MVP

I have a simple expression (Contract Date > Date()) but i woul dlike to see
result as TRUE / FALSE or YES/NO however in my query it shows up as -1 or
0... how can i fix it?

 

[Klatuu]

Sorry it was a syntax error I got from copying your original expression. I
should have caught it. It should be:

SomeDate: IIf([Contract Date] > Date(), "YES", "NO")
--
Dave Hargis, Microsoft Access MVP

Tried that (query Builder)... keep getting an error message saying that my
expression has a wrong number of arguments

In Your Query builder, use a calculated field:

SomeDate: IIf([Contract Date] > Date()), "YES", "NO")

in SQL it would be
SELECT IIf([Contract Date] > Date()), "YES", "NO") AS SomeDate .....
--
Dave Hargis, Microsoft Access MVP

I have a simple expression (Contract Date > Date()) but i woul dlike to see
result as TRUE / FALSE or YES/NO however in my query it shows up as -1 or
0... how can i fix it?

 

[Agent_KGB]

Dave, you ROCK!!!

Sorry it was a syntax error I got from copying your original expression. I
should have caught it. It should be:

SomeDate: IIf([Contract Date] > Date(), "YES", "NO")
--
Dave Hargis, Microsoft Access MVP

Tried that (query Builder)... keep getting an error message saying that my
expression has a wrong number of arguments

In Your Query builder, use a calculated field:

SomeDate: IIf([Contract Date] > Date()), "YES", "NO")

in SQL it would be
SELECT IIf([Contract Date] > Date()), "YES", "NO") AS SomeDate .....
--
Dave Hargis, Microsoft Access MVP


:

I have a simple expression (Contract Date > Date()) but i woul dlike to see
result as TRUE / FALSE or YES/NO however in my query it shows up as -1 or
0... how can i fix it?