Hello all.

I'm not very familiar with Access; my DB experience is primarily in
FileMaker Pro. I'm doing a learning by doing experiment before I jump
head into Access.

My question is this: I have some records that I do not want to be
output to a report. The way I set this up is with a Check Box, if the
box is checked, I do not want this record to be output to the report.
What would my expression be, IF Table1 (checkbox) >= 1 THEN omit
record?


My syntax is horribly off track, this I know. Would I even attack this
from an IF/THEN point of view. Their is this rather nifty operator of
"null" that I've never used before. My other concern is that if I have
3,000 records, setting up a loop if/then script could bog down
server/client.

Someone please assist in putting my train on the tracks, it is much
appreciated in advance.

Thanks,

Ben

Why not create a simple query and put a criteria on your field "is True" and
then base your report on the query instead of the table?

eg. SELECT * FROM myTable WHERE myField Is True;"

By the way....

True = -1
False = 0

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

"Ben" <benross7 (AT) hotmail (DOT) com> wrote

On Wed, 29 Oct 2003 22:19:40 GMT, "Bradley"
<bradley (AT) REMOVETHIScomcen (DOT) com.au>

Why doesn't MS use a more conventional definition of True being any
non-zero value?

"Al Lewis" <big (AT) boss (DOT) man> wrote

Who knows I guess because it's stored that way?
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

Al Lewis <big (AT) boss (DOT) man> wrote

Hello Al,

The reason is due the the fact that a Yes/No data field can have three
options. Yes(-1), No(0) and Null. Hence, you need to be specific as
to the criteria used to source your data.

Regards,

Ray

You can use True and False can't you?

John

jobrien at acscience dot com


raycait (AT) excite (DOT) com (Ray) wrote in message news:<20ba9f4a.0311030530.55ecc15f (AT) posting (DOT) google.com>...