maximum values in access query

M

Miguel

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
 
S

Sunil

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
 
Top