why rows repeated in this cross tab query ?

[siamandm]

Hi i have a crosstab query and I noticed that it repeat row and make it twice,
could you help me to find why is that and how to solve it
https://www.dropbox.com/s/5cxh9il5h6qjm ... 2.zip?dl=0
regards

[Rudi]

It is duplicating the BenefID because there are multiple dates for each ID.
If you remove the DateReceived field out of the query (or count by date), it will summarize to one record per BenefID.

[siamandm]

thanks ruddy