Generating Labels question (Access 2000) 1

[sbourget]

I have a query holding the following information:

ID# Week# Unit# Council Count_of_people
001 1 99 DWC 25
002 1 145 CYC 15
003 1 929 GMC 10

I would like to take the field "count_of_people" divide it by 7, round up and print that many labels for that record.
How would that be done?

Any help would be appreciated.
Thanks in advance

 

[CosmoKramer]

Check out this faq: faq703-3276

It should be enough to get you started......



A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
Douglas Adams