how to avoid duplicate column values in access reports?

[Karoly]

I have a report which shows two columns - staff number and visit date. For a staff number (which is unique) there may be more than one visit date. But I want to list a staff number only once and not multiple times in the column (but want all the visit dates of course). How can I do that?

[ADezii]

1. Open Report in Design View.
2. Select the Staff Number Text Box iin the Detail Section.
3. On the Menu Bar; View ==> Properties.
4. Select the Format Tab.
5. Set the Hide Duplicates Property to Yes.

[Karoly]

Thanks ADezii,

I had to struggle along by creating a new temporary table just for sifting to avoid duplicates. It is little things like these that make things lot easier.

Can you answer one more question?
I want to count the number of records in each group and display it in a third field. How can I do that?

[ADezii]

Let's assume you have a Group Level on a Field named [Staff#]. To Count the Number of Records for each Grouping Level of [Staff#]:

1. Create a Group Footer for [Staff#].
2. Create an Unbound Text Box in the [Staff#] Group Footer.
3. Set the Control Source Property of this Text Box to =Sum([Staff#]).