RE: [MS_AccessPros] Base a Report on a Checkbox

John,

A table may have a yes/no field that is represented in forms and other views as a check box. The field actually stores -1 for True/Checked/Yes and 0 for False/unchecked/No. You can use any of these values in the criteria of your report's record source query.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: jlinux@comcast.net
Date: Wed, 23 Nov 2011 17:49:59 +0000
Subject: [MS_AccessPros] Base a Report on a Checkbox

Is it possible to base a report on a group of records that have a Checkbox checked?

Thanks,
John

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/