Results 1 to 2 of 2
  1. #1
    New Lounger
    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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts