need to set up a query - never used before

[dkstockstill]

I posted this in the general questions and was referred to queries:

I'm using Access 2007. We have a database of names and addresses that we
send 3 different publications to. We also have International clients. I
know how to use the filter to just show people with certain publications and
people that are internationals. When I go to print labels for clients I have
to use filters and then create labels. Is there a way to do this with less
steps? I have never used macros, is that what I need?

You need Queries (and to base your labels report on a Query).

Not knowing anything about the structure of your tables, I can't say just what
those queries would be - but the logic is very much the same as setting up a
Filter. John W. Vinson [MVP]

Ok: Here's how they're set up. I have one table called Publications. We
have the clients name and address and then which publications they receive.
We have 3 publication fields and we put yes or no for each of the three
publications. How do you set up a query to show clients that a particular
publication and then a label report from that query? Any help would be
greatly appreciated!
Thanks,
Kelly

 

[John W. Vinson]

Ok: Here's how they're set up. I have one table called Publications. We
have the clients name and address and then which publications they receive.
We have 3 publication fields and we put yes or no for each of the three
publications. How do you set up a query to show clients that a particular
publication and then a label report from that query? Any help would be
greatly appreciated!
Thanks,
Kelly

You have the name of the client in the Publications table? Are there
publication fields in the Clients table, the Publications table, or what???

You can see your database. I cannot. Please post the names of your tables; the
relevant fieldnames; and some sample data. I very strongly suspect you're
using a "spreadsheetish" table design with the names of publications as
fieldnames, which is a Bad Idea and will make your query difficult, but
without knowing more about your structure I can't say.

I will toss this out: if each Client can get many publications (two is
"many"), and each publication can go to multiple clients, you need three
tables:

Clients
ClientID <Primary Key>
LastName
FirstName
<other biographical data about the client>

Publications
PublicationID <Primary Key>
Title
<other information about the publication as a thing in itself>

Subscriptions
ClientID <who gets the publication, link to Clients>
PublicationID <what they get, link to Publications>
<any other info about this client's subscription to this publication, e.g.
start date, etc.>