using the update query

[Castor]

Hi,

I am struggling to get the update query working. This is
what I want to do:

Table1 has the following fields:

Origin Destination Equipment Rate Time Stamp
Newyork Houston A $1000 04/20/2003
Newyork Houston A $1200 09/25/2003

Now I want to run a qery which would only take the records
with the latest time stamp i.e. in the above example Table
2 would be populated with the record with timestamp of
09/25/2003.

How can I do this? Tks a lot for your help. Castor

 

[Larry]

-----Original Message-----
Hi,

I am struggling to get the update query working. This is
what I want to do:

Table1 has the following fields:

Origin Destination Equipment Rate Time Stamp
Newyork Houston A $1000 04/20/2003
Newyork Houston A $1200 09/25/2003

Now I want to run a qery which would only take the records
with the latest time stamp i.e. in the above example Table
2 would be populated with the record with timestamp of
09/25/2003.

How can I do this? Tks a lot for your help. Castor
.
Use a aggregate query and set the time stamp to max