Link to home
Start Free TrialLog in
Avatar of aplona
aplonaFlag for United States of America

asked on

Basic Access Query Question

I have a query that i am running in access and it is pulling from fields that are true/false check boxes.  I need the result out of the query to show T or F.
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Here is another one:


SELECT Choose (Abs([YourField]) , "F", "T")  As AlphaTF  FROM SomeTableName

mx
Avatar of aplona

ASKER

Thanks, i tried to award th points in the order i received the postings