multiple results in query

  • Thread starter Thread starter Gurtz
  • Start date Start date
G

Gurtz

Hello,

Is there a way to adjust a sql query so that it does not
return multiples? Or do I have to do this in code?

Thanks,
Gurtz
 
In the sql try "distinct" after select so it would be:

SELECT DISTINCT mytable.[myfield] FROM mytable;
instead of
SELECT mytable.[myfield] FROM mytable;

or

right click in the query to show the query properties box
and make Unique values = yes

Hope this helps
 
Thanks, that's perfect!
Gurtz
[email = no $]
-----Original Message-----
In the sql try "distinct" after select so it would be:

SELECT DISTINCT mytable.[myfield] FROM mytable;
instead of
SELECT mytable.[myfield] FROM mytable;

or

right click in the query to show the query properties box
and make Unique values = yes

Hope this helps
-----Original Message-----
Hello,

Is there a way to adjust a sql query so that it does not
return multiples? Or do I have to do this in code?

Thanks,
Gurtz
.
Click to expand...
.
Click to expand...
 
Back
Top