|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 16th, 2004, 03:58 PM
|
|||
|
|||
remove duplicates
Hello,
How can I make a query on a specific field of a column so that it return all the values of the field but without showing duplicate entries? Thanks, Daniel 
|
|
#2
October 16th, 2004, 06:57 PM
|
|||
|
|||
|
Hi Daniel
If you right click somewhere in the Query Design Grid and select Properties from the menu, you can change the Unique Records property to Yes. Alternatively, if your query is counting records then show 'Totals' in the grid and then select GroupBy. HTH Lee "Daniel" wrote: Hello, How can I make a query on a specific field of a column so that it return all the values of the field but without showing duplicate entries? Thanks, Daniel
|
|
#3
October 16th, 2004, 06:57 PM
|
|||
|
|||
|
Hi Daniel
If you right click somewhere in the Query Design Grid and select Properties from the menu, you can change the Unique Records property to Yes. Alternatively, if your query is counting records then show 'Totals' in the grid and then select GroupBy. HTH Lee "Daniel" wrote: Hello, How can I make a query on a specific field of a column so that it return all the values of the field but without showing duplicate entries? Thanks, Daniel
|
|
#4
October 16th, 2004, 06:57 PM
|
|||
|
|||
|
Hi Daniel
If you right click somewhere in the Query Design Grid and select Properties from the menu, you can change the Unique Records property to Yes. Alternatively, if your query is counting records then show 'Totals' in the grid and then select GroupBy. HTH Lee "Daniel" wrote: Hello, How can I make a query on a specific field of a column so that it return all the values of the field but without showing duplicate entries? Thanks, Daniel
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| remove the filter | Dan | Using Forms | 1 | September 30th, 2004 05:47 PM |
| How are duplicates suppressed? | Sam Hobbs | Setting Up & Running Reports | 3 | September 3rd, 2004 03:12 AM |
| Triming info and remove duplicates | James | General Discussion | 8 | August 5th, 2004 03:12 PM |
| Remove border line of a few cells | Raymond | Worksheet Functions | 1 | June 29th, 2004 06:13 PM |
| office 2000 remove tools | bud | Setup, Installing & Configuration | 1 | May 27th, 2004 10:40 AM |
Linear Mode
