harley

I need to query some info. by date but by the most recent date and in a descending order.

BillSoo

I'm assuming this is some kind of database question. Are you using ADO? DAO? SQL? What does your code look like right now?

"I have a plan so cunning you could put a tail on it and call it a weasel!" - Edmund Blackadder

harley

I'm using dao, here's an example: the query lists car info. by license plate ,yet the database can have the same plate# more than once, what I need is ordered by the most recent date in descending order. Hope this helps.

Data1.RecordSource = _
"SELECT * FROM car WHERE plate='" & _
txtplate.Text & "'"
Data1.Refresh

BillSoo

Try:

"SELECT * FROM car WHERE plate = " & plate.text & " ORDERED BY date DESC"

where date is your date field

"I have a plan so cunning you could put a tail on it and call it a weasel!" - Edmund Blackadder