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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The query cannot be completed. 1
Too many IIFs 2
Query to Report Glitch 1
Lower of in a query 2
Criteria on calculated field in parameter query 2
Compare Tables (Vlookup?) 5
Grouping By Date 1
1) Run query through a table and 2) keep (or throw away) records 3

Top