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

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

Seems Working

 

[vbaInet]

Good job vdaniela!

Try DISTINCTROW too. That should work and it will be faster.

 

[vdanelia]

Thank you vbaInet for the suggestion,
I changed it to Distinctrow, but not worked:

SELECT DISTINCT [QUERYDATA].Product, UnitPrice, SumAll, DateOfPurchase, Account, AccType
FROM QUERYDATA;
This is My Variant and working

then changed to

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

Not Worked, I wonder Why?

 

[vbaInet]

Can I see your database? I will tell you why.

 

[vdanelia]

Hello vbaInet Thank you for your reply..
I have also another question about this....
I want to do the same with continuous form too.
I have one form which displays the records as it was described above in my report, now I need to DISTINCT the records on the continuous form... how to do this..
Must I create the query with distinct and then set the form as main source, or there is another way to solve that task..

Thank you Very much in advanced

 

[vbaInet]

If the Record Source of the form is DISTINCT then the records that get displayed will be distinct too.

 

[vdanelia]

Ok then I will do as i did with the report, now everything is clear, I thought that there may be another variant of doing this..
Greatest Thanks vbaInet
Your help is highly appreciated

 

[vbaInet]

You're welcome!