Print Order Sort - 3 sections per page - to be cut and stacked
in [Queries]
|
From: MSweetG222 on 4 Jun 2010 21:07 I have a query/report that prints 3 sales slips per page. I need to sort the query so that when the user cuts the report into to thirds that they can stack the top 1/3 on the middle 1/3 and then stack the new top/middle 2/3s on the bottom 1/3. Once stacked, all the salespeople sales slips are together and order. Example: ------------------------------------------------ Page 1 - Top - Salesperson1 Page 1 - Mid - Sales person2 Page 1 - Bottom - Salesperson3 Page 2 - Top - Salesperson1 Page 2 - Mid - Sales person3 Page 2 - Bottom - Salesperson4 Page 3 - Top - Salesperson2 Page 3 - Mid - Sales person3 Page 3 - Bottom - Salesperson4 Thank you for any assistance. MSweetG222
From: Allen Browne on 4 Jun 2010 21:52 You will need to create a temporary table to hold the records for the report. To create the report: a) Execute a Delete query to clear any existing records from the temp table. b) Execute an Append query to add the records. c) In VBA code, OpenRecordset, and loop through the records numbering them sequentially from zero. Then in the report's sorting and grouping box, enter 2 rows for sorting: =[SortOrder] Mod 3 [SortOrder] The first expression will sort all the exact multiples of 3 first, then those with 1 remaining, then those with 2 remaining. The second line sorts correctly within those 3s. (Hope I've understood you correctly here.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "MSweetG222" <MSweetG222(a)discussions.microsoft.com> wrote in message news:02BC0E71-D841-422D-A7FB-3B4850672A20(a)microsoft.com... > I have a query/report that prints 3 sales slips per page. > > I need to sort the query so that when the user cuts the report into to > thirds that they can stack the top 1/3 on the middle 1/3 and then stack > the > new top/middle 2/3s on the bottom 1/3. Once stacked, all the salespeople > sales slips are together and order. > > Example: > ------------------------------------------------ > Page 1 - Top - Salesperson1 > Page 1 - Mid - Sales person2 > Page 1 - Bottom - Salesperson3 > > Page 2 - Top - Salesperson1 > Page 2 - Mid - Sales person3 > Page 2 - Bottom - Salesperson4 > > Page 3 - Top - Salesperson2 > Page 3 - Mid - Sales person3 > Page 3 - Bottom - Salesperson4 > > Thank you for any assistance. > > MSweetG222 >
|
Pages: 1 Prev: Optimization of Between Clause Queries Next: date and time query |