Using group by in select query..

[Appache]

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.

 

[Klatuu]

You can use a Group by in a Select query.

 

[Appache]

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 ?

 

[Klatuu]

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.

 

[Appache]

Perfect..It was an easy question but I didnt know that.. Thanks very much..