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

  • Thread starter Thread starter Agent_KGB
  • Start date Start date
A

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?
 
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 .....
 
Tried that (query Builder)... keep getting an error message saying that my
expression has a wrong number of arguments

Klatuu said:
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


Agent_KGB said:
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?
Click to expand...
Click to expand...
 
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


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

Klatuu said:
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


Agent_KGB said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Dave, you ROCK!!!

Klatuu said:
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


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

Klatuu said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Klatuu said:
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


"Agent_KGB" wrote:

> Tried that (query Builder)... keep getting an error message saying that my
> expression has a wrong number of arguments
>
> "Klatuu" wrote:
>
> > 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
> >
> >
> > "Agent_KGB" wrote:
> >
> > > 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?
Click to expand...
Hello Dave

I am an Access Novice and would like it to calculate the following,
I am trying to get it to calculate the following: if field [VATable Yes or No] = "Yes" then divide [Amount] / 6

I want it to calculate the VAT into the [Amount] field if yes is checked in the [VATable Yes or No] field,

Please help!!!
 
Back
Top