Re: Label Count

Tech-Archive recommends: Fix windows errors by optimizing your registry

Assuming that each label is a detail row,
-- Add a control to your layout
-- Set its control source to =1
-- Set Running Sum to Over all or Over group (depending on your need)

That should give you a one-up number for each label.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"klp via AccessMonster.com" <u19032@uwe> wrote in message
news:6c79a4bdfbb24@xxxxxx
I have a report, based on the label wizard, that needs to be 4" X 3".
However
it will not take it when it's sent to the printer. Therefore we are trying
to
work our way around it by making it 4" X 6". It will then print 2 labels
to a
page per say. What I need is a counter. If I put in that I need 10 labels
it
will say "1 of 1, 1 of 2, 1 of 3" etc. I can't use the page function
since
it thinks that it's 1 page. I would like to create some sort of counter.
Not
sure if I need to use a query(SQL) or if I need to do something else. Any
suggestions please.

Thanks in advanced.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200701/1



.

Relevant Pages

  • Re: Upper case for control source
    ... It cannot be a Label control. ... Labels do not have a Control Source, ... is attached to the report. ... The financial years are FY05 for 2005, FY06 ...
    (microsoft.public.access.reports)
  • Re: Store data from text box
    ... Each label is created by the data inputed into the ... in the control source of a Form or a Report textbox. ... controls in a Query. ...
    (microsoft.public.access.gettingstarted)
  • Re: Silly Question
    ... Change the label to a textbox, then use this expression as the textbox's ... Control Source: ... Unless you are the intended recipient of the message ... > Checked by AVG anti-virus system. ...
    (microsoft.public.access.reports)
  • Re: Programming some nuances
    ... Change the Control Source of tyour Desposit Date text box to: ... Right-click the attached label, and Change To | Text Box. ... Tips for Access users - http://allenbrowne.com/tips.html ... Total and makes the user-prompted adjustment to it. ...
    (microsoft.public.access.reports)
  • Re: Access 2003 Report - want only one field with a value to show
    ... box with the below Control Source: ... "Duane Hookom" wrote: ... Punchvalue - value of this coupon if it is a special Punch coupon ... Each field has a Fieldname label attached to it. ...
    (microsoft.public.access.reports)