check box query

[Toolpusher]

I need to create a query on a table for a report. The table includes two check boxes one called negative one called positive. You can have a record with either check box ticked or neither but the form does not allow you to have both ticked.
I want a query for a report that will show each record that has one or the other check boxes ticked but not showing the records that have neither check box ticked. Cant seem to be able to create this any help appreciated

 

[nanscombe]

It sound like you want something along the lines of ...

SELECT * FROM yourTable WHERE [Negative] <> [Positive] ORDER BY FieldX

This will only retrieve records where Negative is not equal to Positive therefore it won't show records where both fields are either TRUE or FALSE.

 

[Toolpusher]

Thanks Nanscombe works perfect