I have this in a query design (SQL view) for a listbox:
Format(tblPrintOrdDistribution.PrintOrdDetailComplete) AS Complete
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?