problems with "group by"

  • Thread starter Thread starter sheetal
  • Start date Start date
S

sheetal

My database is not returning duplicates in the query. The governing
criteria is "group by", but this takes only the first value of a series
of duplicates and returns this value. I require all values to come
back. please help me by advising on which function to use.

Thanks

Sheetal
 
If you want duplicates, then you cannot use group by. Group by combines like
items into one.

Beyond that, I cannot help since I don't understand what you want to do.
 
My database is not returning duplicates in the query. The governing
criteria is "group by", but this takes only the first value of a series
of duplicates and returns this value. I require all values to come
back. please help me by advising on which function to use.
Click to expand...

Well, Group By does what it says: assembles the records into groups.
If you don't want to group, don't group! In the query design grid, try
unselecting the Totals query icon (the Greek Sigma). If you would care
to post the SQL of your query it might be easier for us to see what
you're doing!
 
Back
Top