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.
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.
. I've removed your old thread and moved this one to a section that may get some more answers.