Label Count

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

  • Mailing List code bug for FredG
    ... address labels and to start at a specific position on the first page. ... Then add a Report Header to the label report. ... Name this control SkipCounter ... then how many times to repeat each label. ...
    (microsoft.public.access.reports)
  • RE: Making a report that can leave records blank based on user inp
    ... > labels but also lets you skip the labels already used. ... > print multiple copies of the same report. ... Set the Height property for both the report header ... >> I am making a database of a large video archive. ...
    (microsoft.public.access.reports)
  • RE: Making a report that can leave records blank based on user inp
    ... I also have a DVD database that I designed in ms Access. ... >> labels but also lets you skip the labels already used. ... >> print multiple copies of the same report. ... Set the Height property for both the report header ...
    (microsoft.public.access.reports)
  • RE: Report Parameters and Filters
    ... also stops two labels of the same value being scanned. ... No the report is not filtered by the printed field, ... So that is why I tried to set the parameters in reports query from controls ... Dim cnn As New ADODB.Connection ...
    (microsoft.public.access.reports)
  • RE: Report Parameters and Filters
    ... also stops two labels of the same value being scanned. ... No the report is not filtered by the printed field, ... So that is why I tried to set the parameters in reports query from controls ... Dim cnn As New ADODB.Connection ...
    (microsoft.public.access.reports)