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?

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?

I have a strange problem with Access 2007 which I cant figure out in the design mode. I have form2 which uses a field field1 in form1 in its load event using the notation

field2 = Forms!start!fie ld1.

But in run mode when I close the application when form2 is in focus, the execution runs through the form load event of form2 and causes the following error:
can't find the form 'form1' referred to in a macro expression...