how do i exclude some records to print labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my database I have defined fields to identify inactive records and records
that are siblings (duplicates). When I print the labels, I do not want to
print labels for inactives or siblings. How do I use those two fields to
exclude records when I print labels. I must exclude both siblings and
inactives. Please be specific as I'm not very good at Access. /and I do not
wish to delete inactives or siblings.
Thanks,
Linda
 
Your report should be based on a query. Just modify the query criteria to
exclude records that should not appear.

Since you don't tell us what type of fields they are, I can't give you a
specific answer.
 
Sorry. The fields are "i" (for the inactive) and "Sib" for siblings. i uses
an "x" to make someone inactive and "sib" uses a "y". Thanks for the help.
 
Then in your query under the I field (personally I'd use a more meaningful
full name to make this easier to identify) I'd put...

Not "x"

For the Sib field I'd use...

Not "Y"

That assumes the SIB field is a text field. Personally, I'd make it a Y/N
field type and then your criteria would be...

False
 
Back
Top