MS Access

Jnpeanut,

"I've got a database with a field".
I've got only fields in table. And some of these are yes/no-fields indeed (you might call them Booleans, if you like).

"Its called no charge".
It doesn't matter how it is called, although I doubt (and not in the mood to try) if a space can be part of a field name. Mostly one uses an _ for that purpose. But it doesn't really matter.

The field is on a form, and it can be checked and unchecked. That's how things go.

"it won't print"
It = MS Access?

"the report"
Have a look at the query that the report uses. Maybe the query contains an selection on this field. The solution then would be to change the query.

Hope this helps.


Kees

If I understand correctly, you only want to include those on the report who do not have the checkbox marked. The query that is the basis for your report can handle that. Something like this:

"SELECT * FROM MyTable WHERE [No Charge] = 0"

I believe that Access will store a 0 (false) or a -1 (true) in the [No Charge] column in the table, based on whether or not you've checked the box. If that doesn't work, replace the 0 with the word FALSE.