Hello
I have a table with a break on one column. This creates an automatic A-Z sort.
I want to sort on a date column and maintain the break. How do I override the column with the sort?
Thank you for your help
Beverly Cechetto
Listserv Archives (BOB member since 2002-06-25)
May try breaking on the date column first? You can remove the headers and footers of the date break so it will not be obvious that you are breaking on it.
Robert
Schmidt Interactive Software, Inc.
We now post document examples at our WEB site.
I have a table with a break on one column. This creates an automatic A-Z sort.
I want to sort on a date column and maintain the break. How do I override the column with the sort?
Thank you for your help
Beverly Cechetto
Listserv Archives (BOB member since 2002-06-25)
I think you’re going to have to add a break to your date column first, and then add a break to your “other” column, so that your report will be ordered by date first, then “other”. I think breaks always take precedence over sorts, no way around that.
Remember, you can control how a break “looks” by using the Format - Breaks menu item. If you turn off the Break Footer and Remove Duplicates options for your date break, you’ll probably get the results you’re looking for.
Erich Hurst
Compaq Computer Corporation
(281) 514-9445
Erich.Hurst@Compaq.com
I have a table with a break on one column. This creates an automatic A-Z sort.
I want to sort on a date column and maintain the break. How do I override the column with the sort?
Listserv Archives (BOB member since 2002-06-25)