Query with Yes/No datatype

[janerussel]

I have a combobox where the afterupdate event displays a report with filtered records based on the selection in the box. The field is a yes no datatype.

The interesting thing is in the query when I use the group by for the field the results are -1 and No. What appears in the combo box is Yes or No.

The filter doesn't work on the report. Both yes and no are showing.

Any suggestions.

 

[WaltLukeIII]

A yes/no combo Box actually stores the values of True and False so when you are checking these values you should do it True = Yes, False = No if you are querying on a field I think you only have to check ( = True ) if you want all of the records that are yes.

Walt III
SAElukewl@netscape.net

http://www.muc.edu/~lukewl