Sequentially numbering records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...

Thanks
 
Ricter said:
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...
Click to expand...

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
 
Thanks Larry.


Larry Linson said:
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
Click to expand...
 
You could hide the =1 text box but reference it in another text box like:
=Chr(96+[txtNameOfRunningSumTextBox])
 
Thank you Duane. It worked.
--
Deenos


Duane Hookom said:
You could hide the =1 text box but reference it in another text box like:
=Chr(96+[txtNameOfRunningSumTextBox])

--
Duane Hookom
MS Access MVP

Deenos said:
Hello Larry,

What if you wanted to use letters instead of numbers eg. a. b. c. d. etc.
Click to expand...
Click to expand...
 
Back
Top