multiple results in query

[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

 

[sam]

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

 

[sam]

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

 

[Gurtz]

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
.

.

 

[Gurtz]

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
.

.