Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2014

    Unanswered: Building Query, How can i see values of columns


    I am trying to build a query in Access. i have 240K row, there are probably 50 or so unique values in a particular column I want to filter.

    Is there a way, when building this query, that access shows what the unique values of that column are so I can build the query?

    I know I can do a DISTINCT query, but that seems to much (its obviously not for this 1 particular column or project).

    i assumed that when you are in design mode, Access has a side panel or something that shows the possible values in which to build your query against, or do you have to memorize each columns value for every column?

    there has to be some sort of assistance with this...right?

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    select mycolumn, count(mycolumn) from mytable
    group by mycolumn
    order by mycolumn
    should get you there

    as should
    Select distinct(mycolumn) from mytable
    Replace mycolumn with the name of the column, my table with the name of the table.

    as to how you expresss that in the query designer.... dunno. I use the sql view.

    or use a subquery
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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