MattBaldry
Self Taught, Learn from the Forums
- Local time
- Today, 04:15
- Joined
- Feb 5, 2019
- Messages
- 293
Hi All,
Is it possible to create a query that shows the same record a specified number of times with a column then showing how many times?
Basically I have 6 fields for a label. 5 remain constant, but 1 is a serial number. If I enter 50 in the unbound box on my form I then want the query to show 50 rows of the same data with the 4th column numbered 1 to 50.
I am sure I have seen this done, but I cannot find where I saw it before.
5 fields will be stored in a a table but I don't want the serial number counter stored this will change each time the labels are used.
~Matt
Edit: I am happy to create a temp table to store this data if that makes the job easier.
Is it possible to create a query that shows the same record a specified number of times with a column then showing how many times?
Basically I have 6 fields for a label. 5 remain constant, but 1 is a serial number. If I enter 50 in the unbound box on my form I then want the query to show 50 rows of the same data with the 4th column numbered 1 to 50.
I am sure I have seen this done, but I cannot find where I saw it before.
5 fields will be stored in a a table but I don't want the serial number counter stored this will change each time the labels are used.
~Matt
Edit: I am happy to create a temp table to store this data if that makes the job easier.
Last edited: