Help with Access 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SafetyIntern - 04 Jan 2008 19:29 GMT

I have a database set up for contractors and information that is sent to
them. I have tried making a report to pull up which contractors that I have
not sent information to, and have had no luck. I know that when you run a
query it looks for information that 2 tables have incommon. One table is for
the contacts, which includes there information, the other table is a series
of checkboxes for the information I have to send to them. How can I run a
report to show if any of the check boxes are unmarked? I am very new to
access and am about to pull my hair out. Thanks in advance for any help

Reply to this Message

Ron2006 - 04 Jan 2008 20:53 GMT

On Jan 4, 12:29 pm, SafetyIntern
<SafetyInt...@discussions.microsoft.com> wrote:

> I have a database set up for contractors and information that is sent to
> them. I have tried making a report to pull up which contractors that I have
[quoted text clipped - 4 lines]
> report to show if any of the check boxes are unmarked? I am very new to
> access and am about to pull my hair out. Thanks in advance for any help

In the query wizard viewer click the line between the two tables.
You want to select the type of like where you are getting ALL records
for the contractors and only those for the information table that
match. (typically this is the # 2 selection.)

Then select any information from the contractor table that you watn to
see And now the important part.
select the matching ID number or whatever is used to match the two
tables and select the one from the information table (Not the one from
the contractor table) and place a condition on it that says "Is Null"

Run the query now.

Ron

Reply to this Message