Converting -1 and 0 into Y or N on select

[research]

Hello,

Could someone tell me is it possible to convert a particular column from 0/-1 to show y/n instead? Its just a simple select statement I'm doing and I need a Y or N instead or numeric!

Thanks,

R

 

[addy]

Are you wanting to change the data in the table itself or just the way it displays on a form or report whilst keeping the original data?

 

[KeithG]

Open your table in design veiw and change the format of the field to Yes/No instead of -1/0