most recent entries

[tom4038]

hi

im abit new to this access, wonder if anyone can point me in the right direction.

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.

Hope the above is clear, any questions please ask!

thanks again!

 

[pbaldy]

This type of thing?

http://www.baldyweb.com/LastValue.htm

 

[tom4038]

all sorted, thanks

getting use to this access stuff!

 

[pbaldy]

Sorry, I'm on the road right now and only sporadically checking in. Glad you got it sorted out.