Sort by oldest date first (records)

[mosh]

Hello All,

I currently have a form where I would like the form to display the oldest account first, so the overall objective is the employee will action the oldest account first and then go onto the next one etc.

Can anyone please tell me how to do this?

Thank You.

Mos
________
Park Royal 3 Condos Pattaya

 

[edtab]

Try sorting your record source on the primary key asceding order.

 

[lightray]

The best place to do this is in a query, what is your record source? the table or a query?