Prev: Printing to an IP Address
Next: Print Report Landscape
From: Deenos on 13 Apr 2010 17:01
Hello Larry,

What if you wanted to use letters instead of numbers eg. a. b. c. d. etc.
--
Deenos


"Larry Linson" wrote:

>
> "Ricter" <Ricter(a)discussions.microsoft.com> wrote in message
> news:D0310277-87D3-48DA-81E2-81786706CAF2(a)microsoft.com...
> > The tables are, for example, tblContainers and tblItems. A container may
> > have one or more items, so they've been related this way.
> >
> > Generating the report that subdivides items by their container is easy.
> > What I'd like to know is how can I sequentially number the items, 1 to n,
> > regardless of the container they're in? That is, if I have 100 items
> > packed
> > in 5 containers, I want the report to show a unique Item No. next to each
> > item...
>
> Add a Calculated Control, with a Control Source of =1. then set its
> RunningSum property to "Over Group." Set the order in which you want the
> items to appear by some "real" field, if it's important, because all this
> does is sequentially number the items in whatever order they appear.
>
> Larry Linson
> Microsoft Access MVP
>
>
>
From: Duane Hookom on 13 Apr 2010 23:21
You could hide the =1 text box but reference it in another text box like:
=Chr(96+[txtNameOfRunningSumTextBox])

--
Duane Hookom
MS Access MVP

"Deenos" <Deenos(a)discussions.microsoft.com> wrote in message
news:CBD7B782-C1DC-4CF1-BC70-726F1F1DEEA6(a)microsoft.com...
> Hello Larry,
>
> What if you wanted to use letters instead of numbers eg. a. b. c. d. etc.
> --
> Deenos
>
>
> "Larry Linson" wrote:
>
>>
>> "Ricter" <Ricter(a)discussions.microsoft.com> wrote in message
>> news:D0310277-87D3-48DA-81E2-81786706CAF2(a)microsoft.com...
>> > The tables are, for example, tblContainers and tblItems. A container
>> > may
>> > have one or more items, so they've been related this way.
>> >
>> > Generating the report that subdivides items by their container is easy.
>> > What I'd like to know is how can I sequentially number the items, 1 to
>> > n,
>> > regardless of the container they're in? That is, if I have 100 items
>> > packed
>> > in 5 containers, I want the report to show a unique Item No. next to
>> > each
>> > item...
>>
>> Add a Calculated Control, with a Control Source of =1. then set its
>> RunningSum property to "Over Group." Set the order in which you want the
>> items to appear by some "real" field, if it's important, because all this
>> does is sequentially number the items in whatever order they appear.
>>
>> Larry Linson
>> Microsoft Access MVP
>>
>>
>>
From: Deenos on 14 Apr 2010 14:17
Thank you Duane. It worked.
--
Deenos


"Duane Hookom" wrote:

> You could hide the =1 text box but reference it in another text box like:
> =Chr(96+[txtNameOfRunningSumTextBox])
>
> --
> Duane Hookom
> MS Access MVP
>
> "Deenos" <Deenos(a)discussions.microsoft.com> wrote in message
> news:CBD7B782-C1DC-4CF1-BC70-726F1F1DEEA6(a)microsoft.com...
> > Hello Larry,
> >
> > What if you wanted to use letters instead of numbers eg. a. b. c. d. etc.
> > --
> > Deenos
> >
> >
> > "Larry Linson" wrote:
> >
> >>
> >> "Ricter" <Ricter(a)discussions.microsoft.com> wrote in message
> >> news:D0310277-87D3-48DA-81E2-81786706CAF2(a)microsoft.com...
> >> > The tables are, for example, tblContainers and tblItems. A container
> >> > may
> >> > have one or more items, so they've been related this way.
> >> >
> >> > Generating the report that subdivides items by their container is easy.
> >> > What I'd like to know is how can I sequentially number the items, 1 to
> >> > n,
> >> > regardless of the container they're in? That is, if I have 100 items
> >> > packed
> >> > in 5 containers, I want the report to show a unique Item No. next to
> >> > each
> >> > item...
> >>
> >> Add a Calculated Control, with a Control Source of =1. then set its
> >> RunningSum property to "Over Group." Set the order in which you want the
> >> items to appear by some "real" field, if it's important, because all this
> >> does is sequentially number the items in whatever order they appear.
> >>
> >> Larry Linson
> >> Microsoft Access MVP
> >>
> >>
> >>
 | 
Pages: 1
Prev: Printing to an IP Address
Next: Print Report Landscape