asked on How format result in a SQL query
I have this in a query design (SQL view) for a listbox:
Format(tblPrintOrdDistribu
Which is fine. The name of the column is "Complete" which is what I want. But the result is showing -1 and I want it to be Yes or No.
What do I do with the syntax to make that happen?
--Steve
Format(tblPrintOrdDistribu
Which is fine. The name of the column is "Complete" which is what I want. But the result is showing -1 and I want it to be Yes or No.
What do I do with the syntax to make that happen?
--Steve
Microsoft Access
Last Comment
mbizup
If possible use case when x = -1 then no else yes end as complete
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Nothing with the syntax...
- Select the column in the query designer
- Right-click and select "Properties"
You can set the format of your Boolean field to Y/N here.
- Select the column in the query designer
- Right-click and select "Properties"
You can set the format of your Boolean field to Y/N here.
Here's a screenshot from the query builder:
![B]()
can you do Format(case when PrintOrdDetailComplete = -1 then 'No' else 'Yes' end) AS Complete