need to set up a query - never used before

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dkstockstill - 14 Feb 2008 19:44 GMT

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

Reply to this Message

John W. Vinson - 14 Feb 2008 21:20 GMT

>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.
[quoted text clipped - 4 lines]
>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.>

Signature

John W. Vinson [MVP]

Reply to this Message