Query-What format do I use to obtain unspecified unique items?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Table has duplicated rows for each item. I need to derive a query list
from the Table that represents each item only once or only one of the rows
representing each item . I’ve tried [unique only], *unique*, *unique number*,
and every possible variation from these. All I get is nada. The query has to
grab general or unspecified items.
 
You need to use groups. Here's an example:

SELECT myfield1, myfield2, myfield3
FROM MyTABLE
GROUP BY myfield1, myfield2, myfield3

Linda
 
On Tue, 7 Jun 2005 16:31:04 -0700, "Daniel Mark" <Daniel
My Table has duplicated rows for each item. I need to derive a query list
from the Table that represents each item only once or only one of the rows
representing each item . I’ve tried [unique only], *unique*, *unique number*,
and every possible variation from these. All I get is nada. The query has to
grab general or unspecified items.
Click to expand...

This has nothing to do with "format" - which controls how a value is
displayed, not *whether* it's displayed.

Create a Query based on your table. View the Query's Properties (right
mouseclick the grey background of the table window or use the View
menu option); set the query's Unique Values property to True.


John W. Vinson[MVP]
 
Back
Top