Access Query To Assign Bag Numbers,[url=http://www.chanel-handbags.us@#$%&/]chanel handbags[/url]
The data is then exported in mailsort code order for printing,[url=http://www.hermesbirkin-bags.us@#$%&/]hermes handbags[/url]. all the 12345 codes go in the same bag etc),[url=http://www.nikeair-max.fr/]air max[/url].
What I would like to do now is add a bag number to the data. So that all the 12345 coded letters are bag 1,[url=http://www.scarpe-hoganoutlet.it/]scarpe hogan[/url], all the 67890 coded letters are bag 2. This will make the bagging of the letters easier.
There is an added complication in that Royal Mail will only accept bags that weigh upto 10kg. Therefore the weight of the letters (which is already inputed into my form) needs to be taken into account. For example if the letters weigh 50g and there are 1000 records with the same code,[url=http://www.northface-jackets.us@#$%&/]the north face outlet[/url], then there would need to be a new bag number every 200 letters (5 bags for 1000 letters weighing 50g).
I can achieve this by using a VBA loop in Access to go through each record and compare the mailsort code with the previous one,[url=http://www.poloralphlaurenoutletonline.us@#$%&/]polo @#$%&[/url]. If it is the same then it gets the same bag number unless there have already been enough to fill the 10kg bag,[url=http://www.truereligion--outlet@#$%&/]true religion outlet store online[/url].
This however is very slow. if the first code has 150 records then these would have a Sub ID of 1 to 150,[url=http://www.lunetteoakley-pascher.fr/]oakley @#$%&[/url], if the second code has 50 letters then these would have a Sub ID of 1 to 50 etc). I could then use the Sub ID to determine if a given code needs more than one bag by dividing the Sub ID by the maximum number of records (determined by the weight of the letter),[url=http://www.valentino-outlet.us/]valentino[/url], rounding it to 0 decimal places and adding 1.

[url=http://www.ftcw.net/bbs/home.php?mod=space&uid=237770&do=blog&quickforward=1&id=2973909]juicycouture@#$%&A business recycled[/url]

[url=http://lightasic@#$%&/forum.php?mod=viewthread&tid=2085496]@#$%& glasses Braun bags hat[/url]

[url=http://ontariocrimestoppers.ca/crimeforum/read.php?5,86871]gucci ACT 2611 Auction Results Sold Property Prices in Weston[/url]

[url=http://ie.ieie.cc/forum.php?mod=viewthread&tid=2787008]gucci bucks Sweet 16's and major bling aren't just for the Hilton sisters these[/url]

[url=http://ontariocrimestoppers.ca/crimeforum/read.php?5,86872]@#$%& 2001 For Ranger Air bag Code 46 What does it mean[/url]