Does anyone know how access actually views boolean? I thought it was 0 or 1. Someone said they think it is +0 and -1. Since Access will display it as true/false or yes/no, I've got no clue. Anyhow, I am trying to update a boolean field with sql, and it's not recognizing anything I give it. Can anyone help? thasnks, Laura