labels for filtered forms

[shumate62]

Help the desperate newbie!
Did I design my database wrong? I created a form with basic name, address
etc. then also include about 10 yes/no boxes to be selected depending on the
type of client, some clients have no boxes checked, some have one and some
have several. I see how to filter the form to search it- and that narrows it
down, but when I run a report for labels every name comes up!
How do I run mailing labels for a filtered result?

 

[Jeff Boyce]

If you created your form before you had any tables for data, then yes, you
did it backwards.

Access is a relational database ... it all starts with the data.

By the way, if you have need for "10 yes/no boxes" today, what's to prevent
you from needing 9 or 11 (or 23) tomorrow? This is also something of an
indication that your database/application may not be designed in a way that
lets Access do what it does best.

If you'll provide more specific description of your data, folks here may be
able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[shumate62]

well it's not too late, I knew there was something wrong with what I
created...
I created a table of data with fields for names, address, phone etc but then
I wanted to be able to filter each person based on one or several
characteristics. (It's a collection of names for an annual event so the
yes/no fields I created as Author, Speaker, Boardmember, Speaker's Guest, but
of course some people are more than one box,
then I created my form so I could just enter the names and check whichever
box pertained-
but that's wrong huh?

 

[Jeff Boyce]

Unlike a spreadsheet, in which you'd just "add more columns" to get more
categories, when you use a relational database like Access, you use the
"relational" aspect.

You are describing a "one-to-many" relationship between a person and the
"characteristics". This means that a person could have one or none (?!OR
ALL?!) of the characteristics.

To get the best use of Access' features/functions, you need to feed it
well-normalized data. If "normalized" and "relational" are unfamiliar, plan
on spending some time coming up to speed on them before expecting Access be
able to use its strengths...

.... or you could just do this in Excel and use the "filter" capabilities
there ...!

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.