|
| 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
February 23rd, 2005, 08:33 PM
|
|||
|
|||
Filter repeated records
I am trying to filter out all the repeated records. I sorted it. I want to know how to filter out all the records that have been shown in precious records. It is like Field 3 133 Emmet ST 133 Emmet ST 133 Emmet ST 500 5th ST 500 5th ST to 133 Emmet ST 500 5th ST -- Yu Wing, Lau 
|
|
#2
February 24th, 2005, 12:26 PM
|
|||
|
|||
|
Just create a select query, select all the fields and then
in query properties set unique values to True. -----Original Message----- I am trying to filter out all the repeated records. I sorted it. I want to know how to filter out all the records that have been shown in precious records. It is like Field 3 133 Emmet ST 133 Emmet ST 133 Emmet ST 500 5th ST 500 5th ST to 133 Emmet ST 500 5th ST -- Yu Wing, Lau .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Query must filter out records beginning with text "192" | Rene Wennekes | New Users | 4 | February 23rd, 2005 01:57 PM |
| How can I filter for the most recent date for each set of records. | lizbee | Running & Setting Up Queries | 1 | October 22nd, 2004 07:57 PM |
| Exclude records in a report | geoff | Setting Up & Running Reports | 6 | August 13th, 2004 09:44 AM |
| Data Filter results no longer show # of records in filtered list | Suzan | General Discussion | 17 | August 5th, 2004 08:47 PM |
| Filter Button | Antonio | General Discussion | 4 | June 16th, 2004 05:21 AM |
Linear Mode
