A very easy question for you guys probably, but what is the format for the "Order By" property for forms?

I want to order my records by date.

Any help is appreciated.

The OrderBy property is a string expression that is the name of the field or fields on which you want to sort records. When you use more than one field name, separate the names with a comma (,).

When you set the OrderBy property by entering one or more field names, the records are sorted in ascending order.

If you want to sort records in descending order, type DESC at the end of the string expression.

For example, to sort customer records in descending order by contact name, set the OrderBy property to "ContactName DESC".

I got this straight from Microsoft Access Help. It explains it better than I could. http://www.access-programmers.co.uk/ubb/smile.gif If you need any help, let me know.

SteveA

Thanks a lot pal, I need to brush up on my SQL!