Sequentially numbering records

R

Ricter

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
 
L

Larry Linson

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

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
 
R

Ricter

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
 
D

Deenos

Hello Larry,

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

Duane Hookom

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

Deenos

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top