duplex printing question, change record order to line up with otherside?

  • Thread starter Thread starter jason boyer
  • Start date Start date
J

jason boyer

i have a report that i need to make the opposite side match up with the correct record. it is setup to print 4 records, 2 across then 2 below. like 4 post cards on a landscape page. records for each customer need to match up with the mailing address on the reverse side. so the records are switched if i were to make the report right now. basicly records start 1 and 2 on the top of the landscaped page then 3 and 4 under. so on the reverse side records need to be 2 and 1 then 4 and 3 under. i havent made the opposite side for mailing address yet. i need some info on how i need to do this. so i guess my question is actually two questions.
1. how do i make the records match up in the order needed to match up the opposite side? and...
2. how do i make the report start page 2 with the mailing address records?

any ideas? thanks in advance.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Pure Javascript Martin Browser Fractals
http://www.eggheadcafe.com/tutorial...4-87a1e53898a5/pure-javascript-martin-br.aspx
 
This ain't pretty but I think it will do what you want. Substitute your
table and field names.
Create a table --
Rec_New --
Rec_NUM New_NUM
1 3
2 2
3 1
4 4

Jason_Boyer_1 --
SELECT YourTable.Data1, YourTable.Data2, YourTable.Addr,
((([YourTable].[Rec_NUM]\4)+1) *1000) + [YourTable].[Rec_NUM] AS RecNum
FROM YourTable;

Jason_Boyer_2 --
SELECT YourTable.Data1, YourTable.Data2, YourTable.Addr,
(([YourTable].[Rec_NUM]\4)+1)*1000+100+[New_NUM] AS RecNum
FROM YourTable, Rec_New
WHERE ((((([YourTable].[Rec_NUM]+1) Mod 4)+1)=[Rec_New].[Rec_NUM]))
ORDER BY (([YourTable].[Rec_NUM]\4)+1)*1000+100+[New_NUM];


Union query to put them together --
SELECT Jason_Boyer_1.*
FROM Jason_Boyer_1
UNION ALL SELECT Jason_Boyer_2.*
FROM Jason_Boyer_2
ORDER BY RecNum;
 
Watch which you select - Head to Toe or Head to Head.
You can shuffle the New_Num around to change how they fall.
 
Back
Top