hi

I have a table containing the following, below is a sample of the data:

PhoneNumber 447903212345
Data id:0001,IO:FE,A0:02D,T0:000 000,A1:02D,T1:000 000,A2:02C,T2:000 000,A3:02C,T3:000 000
TimeDateSent 13/09/09 17:42:18

I would like to run a query giving me the most recent data from any of the PhoneNumbers within the last 24 hours, the unique field is based on the phonenumber.

e.g. if there was 20 telephone numbers listed, i would get 20 results from the query, each listing the PhoneNumbers most recent entry

Hope the above is clear, any questions please ask! im abit new to this access, so please go easy on me!

thanks again!