How do i get a query to display approved or not approved

T

trader151

when i run the query it is displaying the field as a -1 or 0 i need it to
display as approved or not approved

ioixeb.jpg
 
M

Marshall Barton

trader151 said:
when i run the query it is displaying the field as a -1 or 0 i need it to
display as approved or not approved
Click to expand...


Set the text box's (or field's) Format property to Yes/No
 
J

John Spencer

You can use a custom format on the field
"";"Approved";"Not Approved"

OR you can use an expression in the query in a calculated field.
Assumption: Your field is named Approved

Field: ApprovalStatus: IIF([Approved],"Approved","Not Approved")

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Top