Results 1 to 2 of 2
2009-01-13, 23:46 #1
- Join Date
- May 2008
- Thanked 0 Times in 0 Posts
Extract data in access (Access 2003)
Is there a way to extract data, if I have 1, 2, 3, 3, 3, 4, 5, 5, 5, 6, 6, 7, 7, 7, 7, 8, 9, 9.and want to get 1, 2, 4, 8 as a result? Meaning only pull those number that do not repeat.
2009-01-13, 23:57 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Extract data in access (Access 2003)
I assume that you have a table, with each value in a separate record.
Create a query in design view, based on the table.
Select View | Totals to make it into a Totals query.
Add the field that contains the numbers to the query grid.
The Total option for this column will be the default Group By. That's fine.
Add the same field to the next column in the query grid.
Change the Total option for this column to Count.
If you now switch to datasheet view, you'll see the unique numbers and how often they occur.
Switch back to design view.
Enter 1 in the Criteria row for the second column (the count).
The query will now only return the numbers that occur only once.
If you wish, you can clear the Show check box in the second column.