Eliminate redundant values in query

[confuse]

Hi to all..


I'd like to ask some help again, first : how to eliminate the redundant value in a query. I have query named product sold, the calculate works fine but then it will show redundant values. See attached files..

i want to eliminate the redundancy of data. its waste of space.

Thanks....

 

[Rabbie]

Can you post the SQL for your query.

 

[confuse]

Can you post the SQL for your query.

Oppss,sorry rabbie....here take a look,hope you can help..