maximum values in access query

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

Guest

Hi,

I wonder if anyone can help me with this simple question:

I have a table which includes a column with questionnaire numbers (which
contains duplicates) and another column with dates. I wish to write a query
which will return only questionnaire numbers with the latest (maximum) date
as well as those questionnaire numbers for which there are no duplicates.

Can anyone help PLEASE!?

Thank you
 
hi,

may be the below query can help u

select Quest_no,max(Quest_date) from table_name group by quest_no;

Pls let me know if this helps u


Thanx

With regds

Sunil.T
 
Back
Top