Sorting records using more than one field

[barnett]

I am looking for some help sorting records on a report. I have 2 times: "Time1" and "Time2". I want the report to evaluate both times and place the next event first.

In all situations at least one of the fields(Time1 and Time2) will be filled. Sometimes both Times will be filled.

I want the report to ignore the Nulls and evaluate only the filled in data. Plus compare the times if both are filled and sort with the earlist time on top.

Is it possible? How do I do it?

I tried using the Sorting and Grouping table but it won't let me write expression in the code (I tried an iif() statement and it didn't like the commas).

Thanks in advance for the help

[MindBender77]

I am looking for some help sorting records on a report. I have 2 times: "Time1" and "Time2". I want the report to evaluate both times and place the next event first.

In all situations at least one of the fields(Time1 and Time2) will be filled. Sometimes both Times will be filled.

I want the report to ignore the Nulls and evaluate only the filled in data. Plus compare the times if both are filled and sort with the earlist time on top.

Is it possible? How do I do it?

I tried using the Sorting and Grouping table but it won't let me write expression in the code (I tried an iif() statement and it didn't like the commas).

Thanks in advance for the help

I would start in the original query by filtering where Time1 or Time2 is not null. However, I don't believe it's possible to all your asking in one query.

Bender