<div>
try this query<br />
<br />
select itemid, sum(iif([instock]=-1,1,0))<wbr /> as [In Stock] , sum(iif([instock]=0,1,0)) as [Not In Stock]<br />
from tablex<br />
group by itemid
</div>


try this query

select itemid, sum(iif([instock]=-1,1,0)) as [In Stock] , sum(iif([instock]=0,1,0)) as [Not In Stock]
from tablex
group by itemid

<div>
I &nbsp;got an error message &quot;&nbsp;Duplicate output alias as Order_Placed&quot; when run the query as below<br />
<br />
SELECT [PRODUCT INQUIRY].Part_ID, sum(iif([Order_Placed]=-1,<wbr />1,0)) as [Order_Placed], sum(iif([Order_Placed]=0,1<wbr />,0)) as [Order_Placed]<br />
from [PRODUCT INQUIRY]<br />
GROUP BY [PRODUCT INQUIRY].Part_ID;
</div>


I  got an error message " Duplicate output alias as Order_Placed" when run the query as below

SELECT [PRODUCT INQUIRY].Part_ID, sum(iif([Order_Placed]=-1,1,0)) as [Order_Placed], sum(iif([Order_Placed]=0,1,0)) as [Order_Placed]
from [PRODUCT INQUIRY]
GROUP BY [PRODUCT INQUIRY].Part_ID;

<div>
error message<br />
Circular reference caused by alias Order_Placed in query definitions' select list<br />
<br />
<br />
SELECT [PRODUCT INQUIRY].Part_ID, sum(iif([Order_Placed]=-1,<wbr />1,0)) as [Order_Placed], sum(iif([Order_Placed]=0,1<wbr />,0)) as [NO Order_Placed]<br />
from [PRODUCT INQUIRY]<br />
GROUP BY [PRODUCT INQUIRY].Part_ID;
</div>


error message
Circular reference caused by alias Order_Placed in query definitions' select list


SELECT [PRODUCT INQUIRY].Part_ID, sum(iif([Order_Placed]=-1,1,0)) as [Order_Placed], sum(iif([Order_Placed]=0,1,0)) as [NO Order_Placed]
from [PRODUCT INQUIRY]
GROUP BY [PRODUCT INQUIRY].Part_ID;

<div>
<div class="content wysiwyg-content">
I have a table with boolean fields<br />
<br />
[ItemID] as &nbsp;text<br />
[Qty] as number<br />
[InStock] as boolean <br />
[Call_Back] as boolean<br />
<br />
How do I build a query to show how many times the Item is in stock and not in stock. I want to put these results 1 after the other in the query. Thanks
</div>
</div>


I have a table with boolean fields

[ItemID] as  text
[Qty] as number
[InStock] as boolean 
[Call_Back] as boolean

How do I build a query to show how many times the Item is in stock and not in stock. I want to put these results 1 after the other in the query. Thanks

How to output boolean to a query in in Access 2010

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.