Yes/No Field

  • Thread starter Thread starter Denver
  • Start date Start date
D

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
 
Try pulling Red Line into a query by itself, sort it, and then bring it back
into your main query.
 
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));




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

Denver said:
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
Click to expand...
Click to expand...
 
Back
Top