Can a criteria be made to skip repeating information?

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

Guest

I have a table that I am pulling information from that gives the person's
name in a column in adition to the rest of the information. One item I am
pulling for the query is this person's name. I then want to sort the query
by this data, but the information is such as that I only need it once for
each name. It seems like I would be able to just get the person's name from
a different table and not have it repeat, but that is not the case, the table
itself has select information necissary for the query. Is there a way to put
the criteria such that it does not show repeating criteria in a select column?
 
Polarbear said:
I have a table that I am pulling information from that gives the person's
name in a column in adition to the rest of the information. One item I am
pulling for the query is this person's name. I then want to sort the query
by this data, but the information is such as that I only need it once for
each name. It seems like I would be able to just get the person's name from
a different table and not have it repeat, but that is not the case, the table
itself has select information necissary for the query. Is there a way to put
the criteria such that it does not show repeating criteria in a select column?
Click to expand...

Hi Polarbear,

Take a look at the DISTINCTROW keyword in Help.

hth,

LeAnne
 
hi,
I pick up a hint that you may be using more than 1 table.
if you are then you may not have enough joins between the
tables. sometime, because of the data structure, it is
necessary to have more than 1 join. i have has to use as
many as 3 joins. repeating data is a symtom of not enough
joins.
 
Did you try this? In query design view select View from the menu bar and the
Properties. Change Unique Values
from No to Yes.
Does that work?
It may be necessary to limit the number of fields in the query to make it
work. You might have to whittle it down to just the name field actually. But
then you can use this query as a source in a second query that can pull
additional fields from another table.
Hope that helps.

Ed
Polarbear said:
I have a table that I am pulling information from that gives the person's
name in a column in adition to the rest of the information. One item I am
pulling for the query is this person's name. I then want to sort the query
by this data, but the information is such as that I only need it once for
each name. It seems like I would be able to just get the person's name from
a different table and not have it repeat, but that is not the case, the table
itself has select information necissary for the query. Is there a way to put
the criteria such that it does not show repeating criteria in a select
Click to expand...
column?
 
Back
Top