Change SELECT to SELECT DISTINCT? 
Author Message
 Change SELECT to SELECT DISTINCT?

I'm trying to change from 'Select' to 'Select Distinct' on an existing
report.  I've tried changing it in the SQL Query dialog box, but it never
saves the change.  The same question was posted previously by someone else
but there were no replies.  So, how can I make the change?

Using CR 8.5
TIA

--
JohnM



Sun, 13 Feb 2005 00:22:14 GMT  
 Change SELECT to SELECT DISTINCT?
Create a view using Select Distinct, and write your report based on that
view instead of the underlying base table.

Alternatively, set SQLQuery property to the select distinct in VB code.


Quote:
> I'm trying to change from 'Select' to 'Select Distinct' on an existing
> report.  I've tried changing it in the SQL Query dialog box, but it never
> saves the change.  The same question was posted previously by someone else
> but there were no replies.  So, how can I make the change?

> Using CR 8.5
> TIA

> --
> JohnM



Sun, 13 Feb 2005 07:32:45 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. SELECT DISTINCT yields more than SELECT

2. SELECT works, but SELECT DISTINCT fails

3. ? Changing font of Selected text (How to select?)

4. ? Changing font of Selected text (How to select?)

5. SELECT DISTINCT and memo field problem?

6. Does Access support SELECT Count(DISTINCT fieldname) ...

7. VB select distinct Fax, Co_nam from tableA doesn't

8. Why does SELECT COUNT(DISTINCT price) .. not work

9. Oracle Select DISTINCT used to work, now does not

10. How to select distinct into a combo

11. Problem using SELECT DISTINCT

12. Select distinct on 1 field but returns multiple fields

 

 
Powered by phpBB® Forum Software