maximum values in access query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Miguel - 24 Nov 2005 09:39 GMT

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

Reply to this Message

Sunil - 24 Nov 2005 10:47 GMT

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

> Hi,
>
[quoted text clipped - 8 lines]
>
> Thank you

Reply to this Message

Miguel - 24 Nov 2005 12:56 GMT

Hi Sunil!

Thanks so much for your help. Your suggestion works!

Miguel

> hi,
>
[quoted text clipped - 22 lines]
> >
> > Thank you

Reply to this Message