data report problem

[yasinahmad]

Hello for every one

I wish to help me in this example
I have three tables
1- tables for costumer
2- tables for the language which costumer speak
3- tables for the license which the costumer have

I wont to make report by data report to show the data
In the my example I made the report but there are problem (the data is repeated in the report)
I wish know how I can solve this problem
Thanks for every one

[sashi]

Hi there,

try using the [DISTINCT] keyword in your SQL statement.. if that doesn't work..pls post your code segment to validation.. it's much easier in that way.. take care my fren..

sample usage..

  SELECT DISTINCT[fldName] FROM tblNAME;