Grouping and printing labels

Using Access 2007. I have a very simple query with the following

FamID, FamName, StudLast, StudFirst, StudRoom, StudGrd

I've previously created several reports based on this query, grouping
on the FamID field, then sorting the students by their grade in the
detail. Works just fine to pull into various letter-size documents.
This is what I get:

Page #1
Blah blah text
FamName    FamID
1StudFirst 1StudLast   1StudRoom
2StudFirst 2StudLast   2StudRoom
3StudFirst 3StudLast   3StudRoom
Blah blah text

Page #2
Blah blah text
FamName    FamID
1StudFirst  1StudLast  1StudRoom
Blah blah text

....and so on.

My trouble is when I attempt to print on labels, Avery 5160 to be
precise, which are 3 across by 10 down. If I just use the label wizard
the label formatting looks great, but then I get individual labels for
each student and I need the family name and all students grouped on
one label. (I've made sure they all fit vertically, e.g., there are
not too many students to fit on a single label under one family
group.) In other words, in place of Page #1 and Page #2 above, I need
it to be Label #1 and Label #2. Grouping seems to throw the fixed
label size all out of whack.

Any ideas how to make this work?

Thanks much,

When I change to group by family, I can't seem to control the label
size any longer.

8/28/2007 6:03:42 PM
access.reports 4434 articles. 0 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 3


Similar Artilces:

I am recieving emails and they seemed to be getting grouped by subject line and place in an envelop looking thing that will have a + on it if something has been added with the same subject line. The emails can be from totally different people dealing with totally different things on different days. Is there a way to stop this grouping of emails? View | Current View. Check: Show All Messages only. -- Bruce Hagen MS-MVP [Mail] Imperial Beach, CA "Confused emailer" <Confused> wrote in message news:A...

Defaults on Print Sales Documents screen
Is there a way to set defaults on the boxes selected under the Picking Ticket column on the Print Sales Documents screen? Currently when we open the screen, we have to select which boxes to tick and since we always select the same boxes we wondered if there was a way to have them default when the screen is opened so we don't have to click each time. We want the "Picking Ticket Per Site" box, the "Include Kit Components" box and the "Bin Sequenced" box selected as default values. Thanks!! LMG, You can accomplish this with a small VBA customization, b...

Need help grouping charts
I have identical charts which occur on multiple sheets. Is there any wa to group them for editing? When I group the sheets themselves, it seems to deactivate the charts I tried doing it with a macro as an alternative and then flipping th sheets one by one and keying the macro, but I get a message box with: "Run-time error 1004", "Unable to get the ChartObjects property of th worksheet class". Does anyone have any ideas -- Izz ----------------------------------------------------------------------- Izzy's Profile:

Amount in words to be printed on the invoice
Hi Mates, I need to print the invoice amount in words in MRMS 2.0 Any suggestions Thanks this is available through Microsoft. check out the following site: "RK" wrote: > Hi Mates, > > I need to print the invoice amount in words in MRMS 2.0 > > Any suggestions > > Thanks ...

Hope you folks can help me out with a strange one. I have several worksheets formatted in exactly the same way as follows: Col A - width 4 Col B - hidden Col C - width 4 Col D - Width 108 Col E - Width 3 Col F - Width 11 Col G - Hidden Col H - Width 11 & Empty My print range should be Cols A:G (I have used page setup to set the scaling to fit 1 page wide by [blank] pages tall, thus each sheet will print as many pages as required depending on number of rows] When I have the print range set to A:G only columns A:E show on the print preview (and also on the actual print out) and when I m...

Entourage 2008 DAILY calendar crashes once I hit the print button
Every time I attempt to print my DAILY calendar it crashes. The weekly calendar prints okay. I've run Repair Permissions and restarted Entourage again and again. Below is the Error Report I receive whenever I try to print daily calendar: Microsoft Error Reporting log version: 2.0 Error Signature: Exception: EXC_BAD_ACCESS Date/Time: 2010-03-14 14:12:44 -0400 Application Name: Microsoft Entourage Application Bundle ID: Application Signature: OPIM Application Version: Crashed Module Name: Microsoft Entourage Crashed Module Version: 12...

Data labels for Excel 2007 Charts
Hi, I have charts that are based on dynamically populated data. I need the data labels for all of these charts to appear with 0 decimal places. The dynamic data populates with 2 decimal places (X.XX). Is there a universal setting I can apply to the worksheet or even the chart itself, so I do not have to go to each data point/data label and set the formatting to 0 decimal places? Thanks, Courtney ...

Looking for a quick way to create a bunch of labels for annual mailing to diverse contacts
Using Office 2004 (11.2), I have numerous contacts that are part of diverse categories (some have not been categorized yet) I would like to create mailing labels for the annual calendar mailing. As of now I figured out how to select a large number of contacts & mark them as part of the annual card category (Command & click) and go to Word's Data Merge Manager where select the main document & then the address book as a data source. I went to Query Options and selected the category that fits (annual card). Now what? ...

How to print a graph of x=y at 45 degrees
How can I make it appear correctly on paper? Gordon, Set up two sets of points: 0 0 1, 1 Plot them with an x-y scatter chart, line style. Set the x and y axis scales the same, if necessary, to get the resulting plot to be at 45�. Print it, and hope for the best. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "gordon158" <> wrote in message > How can I make it appear correctly on paper? ...

label printing
There should be a way to print labels from all P.O. being received the same day. to avoid wasting labels. ...

Insert Acount# in the PO print
Can some one please let me know where I should place this variable: "PurchaseOrder.Supplier.AccountNumber" in the PO.xml file I woud like to be able to print the Acount # in the PO Thank you jm wrote: > Can some one please let me know where I should place this variable: > "PurchaseOrder.Supplier.AccountNumber" in the PO.xml file > I woud like to be able to print the Acount # in the PO > Thank you > Into receipt header? Open your XML.. and find field date of receipt.. but why you have no AccountNumber into your PO.xml ? Antonio Thank you for a...

Printing a worksheet on 11x17 paper
I want to print a worksheet on 11x17 paper. When I try to change to that paper size in print options, there is no size like that available. What do I do??? thank you for your help in this matter. Katie It's the printer that decides that.. Do you have that option on the printer it should be available in Excel -- Regards, Peo Sjoblom "Katie" <> wrote in message news:9fca01c4345c$bcdca970$a301280a@phx.gbl... > I want to print a worksheet on 11x17 paper. When I try > to change to that paper size in print options, there is ...

adding same note to a group of contacts
As we know there is no histroy in CRm, can not see what has been done to contacts in past or what changes have been made. So if I whated to add the same note to a group of contacts such as : email jhfahf sent on afjak" how would I do it. Or is it just not possible. Alison, Well, you could mess with workflow and stubs do get a kludgy solution - or you could just buy VAST, the ISV add on that solves this problem, and shows you all of the historical change made to CRM! (Please excuse blatant sales pitch - but I don't get such a good leading question too often!) Dave ------...

How do I view my calendar by a label I've created?
I would like to assign label colors to items in my calendars (for home use) and then be able to view my monthly calendar by one label at a time as I choose. Is there anyway to do this? I have gone through all the help menus and can't find anything. I found instructions on how to create a filtered view, but under the instructions, I have no "Add Filtered View" as one of my options. Any suggestions? View | (Arrange By) | Current View | Customize Current VIew | Filter --=20 Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtlefloc...

Printing #2
I understand that NLQ printing is default in windows. Is there any way one can get a quick draft print of excel reports on a dot matrix printer by changing the printer driver or fonts for instance? Thank you. Hiren, I'm not sure about this setting, but try "Draft quality" in File - Page setup - Sheet. -- Earl Kiosterud mvpearl omitthisword at verizon period net President Bush on sovereignty: ------------------------------------------- "Hiren Shah" <> wrote in message news:054901c4961...

Group / ungroup Publisher 2007
I am trying to group 2 pictures in a text box using Publisher 2007 and Vista. The select / unselect items in the Arrange menu are greyed out. I believe I should be able to use the select tool to draw a box around the items but nothing happens when I click on it. any thoughts please Do you have a border on your page? Are you certain you are selecting all the objects? What happens if you do CTRL+A with your cursor outside the text box? -- Mary Sauer MSFT MVP news:// "ancre15" <ancre15@discussions.micro...

Limit value for Storage Groups
Hello, we are running Exchange 2003 Standard edition. The limitation on Storage Groups for e.g. "Issue warning at(KB)" is default set by 2097151. I read that i can change this value by using ADSI Edit and edit the values mDBOverHardQuotaLimit mDBOverQuotaLimit mDBStorageQuota But each of them has a lots of values and i could not find out which one i have to edit. Could you please give me an advice? TIA helpi If you want to set a value bigger than 2GB for all users on an entire mailbox store, bring up the properties of that mailbox store in ADSIEdit and set the mDBStorageQuot...

Bar chart & Category (x) axis labels #2
If you make a bar chart in Excel 2003, and have two columns of text as Category (x) axis labels, the first column is shown vertical and the text in the second column is shown horizontal in the chart. If you open/make the same chart in Excel 97, the text in both columns is shown horizontal. If there is a lot of text, it becomes unreadable when it's vertical. Is this by design or can it be fixed somehow? ...

Import Print Shop files into MS Publisher
Is there any way to import files created in Print Shop into MS Publisher? I need to convert all of my old(er) Print Shop files and am not sure how to accomplish that. Thanks in advance for any info and help. Sigrid What kind of files are you talking about...images? If so, then probably yes, just export (or save) them as standard graphic files. Are you talking about Broderbund's Print Shop? You need to explain exactly what you are trying to do, and what is/is-not happening when you try. -- ~~~~~~~~~~~~~~~~~~ Rob Giordano Microsoft MVP Expression Web ...

Butterfly Labels with Zebra LP2824
We are using a Zebra LP2824 label printer, with the butterfly labels. We are scanning the labels with a Symbol LS2208 barcode scanner. the label size is 2.36inches wide and 0.50inches tall. the problems we are encountering is with the longer itemlookupcodes, when the itemlookupcodes get to be a larger size, store operations shrinks the barcode that is printed onto the labels, these shrinked barcodes will not scan with the LS2208 scanner. If we enlarge the space for the barcode to print onto the butterfly, the label ends up printing accross the whole butterfly, but then you cant wrap...

Print individual forms
I have created a form with several subforms in it. The form contains the same information for a number of different individuals. I would like to print the form for each individual separately. When i try to print it, if prints out the information for all the individuals. How do i do this. I have attached a screen shot of the first page of the form. The problem is that forms are used for user interface, and have things like buttons, radio controls etc. that often hinders the ability to print a form. furthermore you'll often find that the form has background sheeting, and I can waste...

money 2002
In microsoft money - I can no longer print checks - I keep getting the error message "there are no accounts with checks to be printed" - I printed microsoft knowledge ase article 313373 with gives me a resolution that is either incorrect or that I'm not going correctly. Help! If you have more checks to print does it want to print them? See "Marcia R" <> wrote in message news:019701c3b14a$bc496a10$a501280a@phx.gbl... > In microsoft money - I can no longer print checks - I > keep get...

National Accounts for third-party payors or buying groups
Hi all, Are more GP users finding that they are receiving payments from a third-party payor or these national buying groups? Seems like we are seeing an increase and the current National Accounts functionality only takes us so far. When we receive payment from the third-party payor, they are taking Credits or Returns and applying them against unrelated customers. In applying credit memos or the cash receipts, we are having to do some workaround where we move the credit memo to the Parent ID (i.e. third-party payor) and then we can apply it to the other children. Is there a better...

Excel Data to Word Mailing Labels
Has anyone ever done this? I've tried several ways to do this that seem like they should work and they don't. I've been sent several multi-hundred lined worksheets that include mailing label information, and I really don't want to have to type it again by hand into Word. Linda, Tell how your data in the table is laid out. Give a couple of rows of examples. Include the headings. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Linda" <> wrote in message news:0f4901c37bea$c87a5...

Catalog Printing
I'm not sure how, but the way my catalog is printing changed. The pages are no longer in order. Is there any way to change it back so that when I print they are back to normal? ...