making a "for..next" loop to export to excel (1 Viewer)

[Mike1sMike]

Hello,

On a form with [name], [color], [poundage] and [rolls]

My need/want is to export to a new excel spreadsheet based on [name]:
a heading row with: name color poundage rolls
and then the SAME name, color and poundage for the number of rolls there are
so if

Name is Mike, Color is Silver, Poundage is 2000 and Rolls is 12 i would get

Name Color Poundage Rolls
Mike Silver 2000 1
Mike Silver 2000 2
Mike Silver 2000 3
Mike Silver 2000 4
Mike Silver 2000 5
Mike Silver 2000 6
Mike Silver 2000 7
Mike Silver 2000 8
Mike Silver 2000 9
Mike Silver 2000 10
Mike Silver 2000 11
Mike Silver 2000 12

created in an excel file

Am I being dumb?

 

[theDBguy]

Hi. You should be able to create a query in Access with the same result and then export it to Excel. You can do that by using a Tally table. It's a table with nothing but a series of sequential numbers in it. Then, you would use a Cartesian Query to generate the result you want. Take a look at this blog article, as a starter.

Cartesian Query

When creating a query involving multiple tables, we can select from three types of table joins depending on the desired result of the query....

thedbguy.blogspot.com

 

[Mike1sMike]

Hi. You should be able to create a query in Access with the same result and then export it to Excel. You can do that by using a Tally table. It's a table with nothing but a series of sequential numbers in it. Then, you would use a Cartesian Query to generate the result you want. Take a look at this blog article, as a starter.

Cartesian Query

When creating a query involving multiple tables, we can select from three types of table joins depending on the desired result of the query....

thedbguy.blogspot.com

Thank you, again. Funny because the example they are showing is example what i am using it for. Appreciate it!

 

[theDBguy]

Thank you, again. Funny because the example they are showing is example what i am using it for. Appreciate it!

Hi. You're welcome. Let us know if you need more help. Cheers!