Yes/No field showing as 0 -1

P

Penny Miller

I have a table that has a yes/no field in it called "completed", when I
create a query based off of this table this field shows as a 0 or a -1. How
do I code this so it will show either Yes or No?
 
D

Duane Hookom

When you bind this field to a text box in your form or report, set the format
property to
Format: Yes/No
 
P

PennyM

I am really rusty on my coding for I haven't done it in a while and I still
need to make a similar change to a different field that isn't a yes/no field.
This field is a text field called "SPO" and is 3 characters long which is
the probation officers initials.

I need it to say the name of the probation officer name instead of their
initials
SPO = LLL (Lori Lewis)
 
D

Duane Hookom

Include the table that contains both the name and the initials in your query.
Join the initials fields.
 
Top