Print Order Sort - 3 sections per page - to be cut and stacked

  • Thread starter Thread starter MSweetG222
  • Start date Start date
M

MSweetG222

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
 
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.)
 
Back
Top