Help with Access 2003

  • Thread starter Thread starter SafetyIntern
  • Start date Start date
S

SafetyIntern

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
 
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 runa
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 runa
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
Click to expand...

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
 
Back
Top