Chris,
In MS Query use 1 for .T. and 0 for .F.
>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!!!
Daniel