Formatting a Yes/No field

Giganews Newsgroups
Subject: Formatting a Yes/No field
Posted by:  troy (troy.staub…
Date: Tue, 21 Oct 2003

I have a query to an Access database.
The values of Yes/No are showing in excel as 0's and 1's.

Is there a way to format this so it displays as Yes or No?

I don't want to add new columns using a if stmt as my
Yes/No columns come in the middle of output.....