How To Hide Duplicated Entire Row In Reports

[vdanelia]

Hello Dear friends, I have a question. I want to hide or not to display duplicated rows in access report.

I have created a special report for access where the product list is displayed.

Record Example:
# Product | UnitPrice | Quantity | SumAll | DateOfPurchase | Account |AccType |
__________________________________________________ ______________
1. Desktop | 250 | 5 | 1250 | 5/5/2011 | Budget | 100 |
2. Desktop | 250 | 5 | 1250 | 5/5/2011 | Budget | 100 |
3. Desktop | 250 | 5 | 1250 | 5/5/2011 | Budget | 100 |


4. Desktop | 250 | 5 | 1250 | 5/5/2011 | Budget | 100 |
5. Desktop | 250 | 5 | 1250 | 5/5/2011 | Budget | 100 |
6. Scanner | 100 | 3 | 300 | 7/8/2010 | BudgN | 050 |
7. Scanner | 100 | 3 | 300 | 7/8/2010 | BudgN | 050 |
8. Scanner | 100 | 3 | 300 | 7/8/2010 | BudgN | 050 |

Now I think that everything is clear, I just need to be displayed 1 Record not all the identical...

thank you in Advanced

[vdanelia]

I Solved It
First created Query and then set to a report as source

SELECT DISTINCT [QUERYDATA].Product, UnitPrice, SumAll, DateOfPurchase, Account, AccType
FROM QUERYDATA;

Seems Working