D
dwalley
083005 3:35p ET
I work for a newspaper. We need to print "bundle sheets" that will go on top
of stacks of newspapers in bunches of 50. If the remainder is less than 25 it
must be grouped in last group and printed accordingly.
Ex: a route has 220 papers. Therefore, I need to print 3 bundle sheets of 50
and one of 70 because as stated above, if remainder is less than 25 it is to
be combined with final sheet of 50, therefore, final sheet will say 70.
Each sheet must contain text that includes the Zip code, route number,
number of newspapers in bundle (50, 50, 50, 70) and Bundle 1 of 4, Bundle 2
of 4, Bundle 3 of 4, Bundle 4 of 4.
I created the table and a qry that includes RtNumb, ZipCode, Count.
I don't really know VBA so any query or macro suggestions are appreciated.
any takers? Don
I work for a newspaper. We need to print "bundle sheets" that will go on top
of stacks of newspapers in bunches of 50. If the remainder is less than 25 it
must be grouped in last group and printed accordingly.
Ex: a route has 220 papers. Therefore, I need to print 3 bundle sheets of 50
and one of 70 because as stated above, if remainder is less than 25 it is to
be combined with final sheet of 50, therefore, final sheet will say 70.
Each sheet must contain text that includes the Zip code, route number,
number of newspapers in bundle (50, 50, 50, 70) and Bundle 1 of 4, Bundle 2
of 4, Bundle 3 of 4, Bundle 4 of 4.
I created the table and a qry that includes RtNumb, ZipCode, Count.
I don't really know VBA so any query or macro suggestions are appreciated.
any takers? Don