Order By help. Nulls make new record appear first after requery 1

[UHNSTrust]

Hi have forms set up with a button to add a new record. This is fine except the users want the records sorted in a particular order.

They want the records sorted by a date field. This is no problem except when a new record is added and the form is requeried to include the record. Because the order by is set to ascending on the date field any new record has a value of null which is put first. I need the new record at the end but the other completed records ordered by the date field.

Can anybody help? If this does not make sense then please ask for clarification.

Thanks in advance

Jonathan

 

[PHV]

ORDER BY Nz([date field],#2049-12-31#)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[UHNSTrust]

Thanks PH. Exactly what I was looking for. A star for you.

Jonathan