<div>
is PrintOrdDetailComplete an integer?<br />
<br />
can you do Format(case when PrintOrdDetailComplete = -1 then 'No' else 'Yes' end) &nbsp;AS Complete
</div>


is PrintOrdDetailComplete an integer?

can you do Format(case when PrintOrdDetailComplete = -1 then 'No' else 'Yes' end)  AS Complete

<div>
If possible use case when x = -1 then no else yes end as complete
</div>


If possible use case when x = -1 then no else yes end as complete

<div>
Nothing with the syntax...<br />
<br />
- Select the column in the query designer<br />
- Right-click and select &quot;Properties&quot;<br />
<br />
You can set the format of your Boolean field to Y/N here.
</div>


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.

<div>
Here's a screenshot from the query builder:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/03_w11/560475/PropertiesForABooleanField.png" target="_blank" title="B (20 KB)"><img alt="B" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2012/03_w11/800_560475/PropertiesForABooleanField.png" /></a>
</div>


Here's a screenshot from the query builder:

Bhttps://filedb.experts-exchange.com/incoming/2012/03_w11/560475/PropertiesForABooleanField.png

PropertiesForABooleanField.png

<div>
<div class="content wysiwyg-content">
I have this in a query design (SQL view) for a listbox:<br />
<br />
Format(tblPrintOrdDistribu<wbr />tion.Print<wbr />OrdDetailC<wbr />omplete) AS Complete<br />
<br />
Which is fine. &nbsp;The name of the column is &quot;Complete&quot; which is what I want. &nbsp;But the result is showing -1 and I want it to be Yes or No. &nbsp;<br />
<br />
What do I do with the syntax to make that happen?<br />
<br />
--Steve
</div>
</div>


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?

--Steve

How format result in a SQL query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.