Yes/No Field

[Denver]

i have this calculated field in my query, is there anyway i can sort and
display only those with YES value?how? anyone out there is kind to help me...

Red Line: Abs(Sum(IIf([Rd Line]=0,1,0))-([Total Records]))

thanks

denver

 

[Golfinray]

Try pulling Red Line into a query by itself, sort it, and then bring it back
into your main query.

 

[Access101]

I am unable to get the ABS criteria to work, but you can copy/paste this
query into your SQL View to illustrate how a separate field (WHERE CLAUSE) is
used to show only YES values:

SELECT IIf([Rd Line]=0,1,0) AS WhereVal, Abs(Sum(IIf([Rd
Line]=0,1,0))-([Total Records])) AS OtherVal
FROM [Red Line]
WHERE (((IIf([Rd Line]=0,1,0))=Yes));

Try pulling Red Line into a query by itself, sort it, and then bring it back
into your main query.

i have this calculated field in my query, is there anyway i can sort and
display only those with YES value?how? anyone out there is kind to help me...

Red Line: Abs(Sum(IIf([Rd Line]=0,1,0))-([Total Records]))

thanks

denver