Make Empty Field Fall To Bottom

[RichardAnderson]

I have a form that has 2 fields in the OrderBy property. Status and ProduceByDate. It is put into the property as follows.. Status, ProduceByDate. When the form is opened it sorts perfect except for one thing I dont like. If the ProduceByDate is empty, it is sorted on top of other records with dates. I do not want to do DESC because I need the dated nearest in the future to be above ones further out into the future. I thought about put ProducedByDate Is Not Null in the filter property but I still need these records to show. I just want them at the bottom.

[June7]

Try:

Status, Nz(ProduceByDate,#12/31/2999#)

[RichardAnderson]

I tried that but it prompts for user input

[June7]

Well, that was wild thought off top of my head. Just tried it. Works. But slight error in my suggestion. Need [].

Try:
[Status], Nz([ProduceByDate],#12/31/2999#)

However, even when I ommitted the [] I did not get popup prompt so something else may be wrong with your statement. Are both fields actually in the form RecordSource? Are they spelled correctly?