04-29-2008, 05:05 PM
|
#1 (permalink)
|
| Query Queen Join Date: May 2006 Location: Helena, MT
Posts: 45
Rep Power: 0  | Sorting problem I stumped BB support today with this one. I used the same query to generate in Mail envelopes, labels, and quick letters using descending order by Zip code by sorting in Mail. The envelopes and labels sorted consistently with each other. However the quick letters did not in the cases where the Zip code did not include the plus 4 digits at the end of the 5 digit Zip. The fix was to sort the query and then in Mail sort by query instead of by Zip. |