Sorting help [message #184188] |
Tue, 25 July 2006 12:17 |
jbeals
Messages: 4 Registered: July 2006
|
Junior Member |
|
|
I have three queries which have customer number, customer name, and total sales for the month (One for this month, one for last month, and one for the previous month. I have a data link between queries on Customer number, name, but am having trouble sorting from highest sales amount to lowest for last month. I can sort by customer alphabetically, but am not sure how to get it to ignore the first column of current month sales and only sort descending by sales for last month.
Any ideas or assistance would be greatly appreciated!
Thanks!
|
|
|
|