Access Access 2007 Query Date

[TRod]

I am new to using Access 2007. Please help if possible. I have an access 2007 query and I need to sort it by dates. I have 3 field dates... need to sort each field if not null.

I need for it to sort by field1 date first, and it field1 date is null, sort by field2, and if field2 date is null, sort on field3.

I hope I explain it good enough...I am a rookie.

 

[Ian]

Hi and welcome to the forums

Please only make one thread per issue, as having duplicates will confuse things . I've removed your old thread and moved this one to a section that may get some more answers.