Hi, I have a report which is based on a query. If i open the query i get all the data exactly as i want, but if i open the report it's seems like there some data which is lost. At least it's not printed on the report. This is a salary report what i get on the report are everything else except name and person identification. This only happens on some people.

Heeelp

Steven

Are the properties on that field set to
Hide Duplicates - Yes ??

I've solved the problem, the solution for this problem is to change the grouping so instead of grouping of only lastname i grouped on bouth primary key, lastname and firstname. In order to get it asc. sort on lastname and firstname i put them before primary key field.

My problem was that if two or more people had the same lastname, they where grouped together with only of the persons name.

So i'm satified now..

Steven