True values showing - only

In Access2000 front-end, SQL server backend - I have a stored procedure that I am writing. I have several fields that are setup as booleans. I only want the True values to appear on the report that I am going to create. Please see an example below.

JOBNUMBER
7800

SHRINKWRAP
False

JACKETING
True

---------------------
JOBNUM

7801

SHRINKWRAP
True

JACKETING
True

What I need is for the True values to show, and not the False. What's occurring now, is I put > 0 in both the Shrinkwrap and Jacketing criteria fields. The result is the jobs will appar for one or the other, and not both.

Please help.

I know you have had this problem for a while. Can you move some sample data into anb Access DB and include you query and post it. Lets see if we can get this solved for you.

S-

How do I attach a sample DB? I apologize if this is dragging on. I'm very new at this, and it seems as though the different things I try don't work with this project. I too, want to put this one behind me. You've already been a great deal of help, and I appreciate it.

When you reply to this response, about 1.5 inches below the reply box you will see "Attach file". click on the browse and select the file you wish to attach..

S-