By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,469 Members | 2,271 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,469 IT Pros & Developers. It's quick & easy.

Sorting records using more than one field

P: 9
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
Feb 11 '08 #1
Share this Question
Share on Google+
1 Reply


MindBender77
100+
P: 234
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
Feb 11 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.