Hi sorry to post this here (I don't where is best for this one...)

I have a .DBC with tables "customers" and "events" - I am trying to use MS Query to join the two tables on their respective primary keys and then add criteria...

The join works OK - but one criteria I want to add is on a logical field T or F in the table - 0 or 1 I think in MS Query - I know I have records in this logical field that are T but when I add the criteria all records disappear!!!

Please if you know what wrong here - let me know!!!