Using group by in select query..

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

Guest

Hi,
I have a quick question. I have a select query in Access but I want to use
group by, max, min etc. options just like we use in append, make table query.
Is there any way to do it? because of my query have table relations I have
many multiple records. I think thats the only way to get ride of multiple
records for my query.
 
How?
When I open design view I can see field, table, sort, show, criteria but I
dont see anything associated with Group by, max, min, last etc. I don't just
need group by but also I need max, min, last etc. How can I access them?
Should I write sql code manually ?
 
With the query open in design view, on the menu bar is an icon that looks
sort of like the Greek letter sigma. Click it and you will get a new row
just below the Table: row titled Total:
You can select the options for each field from the combo.
 
Back
Top