Filtering a queried table 2

[shbooth]

First let me state that I am new to Access.<br>
<br>
Problem: I have created a table of names and addresses. Each month I query the table and create a file of those people that have used our services this month, most of the time people use this service more then once each month. What I would like to do is have a report and print lables of only one occurence that month. How do I do this and please do not assume that I will understand.......<br>
<br>
Thanks in advance for your help.

 

[DougP]

Make a query (Click on the Queries TAB and click New)<br>
Pick the Table where your data is located.<br>
Add the fields you want on your report i.e. Employee ID, Name, time, etc.<br>
The field that you want only one occurrence needs to be a grouped field.<br>
In the design view of the query click on the &quot;Query&quot; menu then click Crosstab<br>
You will see 2 new sections added at the bottom called &quot;Crosstab&quot; and &quot;total&quot;<br>
click on the query menu again and click &quot;Select&quot; query only Crosstab will disappear.<br>
Click in the totals section and find Group by<br>
Run your query (click on the Red Exclamation mark at the top.)<br>
<br>
You should see only one occurrence of each in that field.<br>
Save the query and call it &quot;qry-Somename&quot; and close it Where some name is a meaning full name.<br>
To create a report based on this query<br>
Click the Reports TAB<br>
Click New<br>
If you want labels click &quot;Label wizard&quot;<br>
Click on the Drop down at the bottom and find your Query (qry-Somename)<br>
Follow the prompts.<br>
You can actually pick the Avery Label number in the label report.<br>
<br>
Hope this Helps<br>
<br>

 

[elizabeth]

Sounds like you already know how to create a filter, and the Label Wizard creates the labels for you, so the missing piece is what to do after creating the labels. See<br>
Second hand help: Print labels for only filtered entries? (last answered on 1/6/2000) for step-by-step directions.