A
Annie France
All,
I posted under reports, but think I should be able to do
this through a query.
What I want is to build an expression that looks at
another field in the query and returns one value (1) if
it's a Y and a zero (0) if it's an N.
I used expression builder, but it wants a parameter passed
when it runs or it'll simply return nothing at all (no
data selected).
I have Y and N values in the database.
Thanks for any help.
Annie
I posted under reports, but think I should be able to do
this through a query.
What I want is to build an expression that looks at
another field in the query and returns one value (1) if
it's a Y and a zero (0) if it's an N.
I used expression builder, but it wants a parameter passed
when it runs or it'll simply return nothing at all (no
data selected).
I have Y and N values in the database.
Thanks for any help.
Annie