If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
duplex printing question, change record order to line up with otherside?
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/tutorials...martin-br.aspx |
#2
|
|||
|
|||
duplex printing question, change record order to line up with othe
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; -- Build a little, test a little. "jason boyer" wrote: 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/tutorials...martin-br.aspx . |
#3
|
|||
|
|||
duplex printing question, change record order to line up with othe
Watch which you select - Head to Toe or Head to Head.
You can shuffle the New_Num around to change how they fall. -- Build a little, test a little. "jason boyer" wrote: 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/tutorials...martin-br.aspx . |
Thread Tools | |
Display Modes | |
|
|