how to get latest date?

[angshubh]

My table structure is

Subscribers
Sub_no (primary Key)
Sub_name

Payments
Sub_No(Foreign Key)
paymentdate

Subscribers.Sub_no is related to Payments.Sub_No as a one-to-many join.

Problem I am facing:
I want to write a query where only the latest date will come out from table Payments for each of the Sub_no.

 

[Rich]

Use a Totals query, Max your date

 

[angshubh]

Great!! Halleluah.. it shd have occured to me earlier.

Thank you very much Rich! I got gthe answer within 2o mnts of my posting!! Keep it up!!!

I'll try to contribute too...