If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sequentially numbering records
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 |
#2
|
|||
|
|||
Sequentially numbering records
"Ricter" wrote in message news 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 |
#3
|
|||
|
|||
Sequentially numbering records
Thanks Larry.
"Larry Linson" wrote: "Ricter" wrote in message news 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 |
#4
|
|||
|
|||
Sequentially numbering records
"Ricter" wrote
Thanks Larry. You're most welcome. Larry |
#5
|
|||
|
|||
Sequentially numbering records
Hello Larry,
What if you wanted to use letters instead of numbers eg. a. b. c. d. etc. -- Deenos "Larry Linson" wrote: "Ricter" wrote in message news 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 |
#6
|
|||
|
|||
Sequentially numbering records
You could hide the =1 text box but reference it in another text box like:
=Chr(96+[txtNameOfRunningSumTextBox]) -- Duane Hookom MS Access MVP "Deenos" wrote in message ... Hello Larry, What if you wanted to use letters instead of numbers eg. a. b. c. d. etc. -- Deenos "Larry Linson" wrote: "Ricter" wrote in message news 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 |
#7
|
|||
|
|||
Sequentially numbering records
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" wrote in message ... Hello Larry, What if you wanted to use letters instead of numbers eg. a. b. c. d. etc. -- Deenos "Larry Linson" wrote: "Ricter" wrote in message news 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 |
Thread Tools | |
Display Modes | |
|
|