Is it possible ?

  • Thread starter Thread starter @pollo
  • Start date Start date
@

@pollo

Hello with you all,
Is it possible from a table like this
item code Des. quantity
A Apple 3
B Orange 1
C Bananas 4


Query result :
A Apple
A Apple
A Apple
B Orange
C Bananas
C Bananas
C Bananas
C Bananas

Thanks for all contribution.

Thanks to have read until there.
 
Dear @pollo:

Create a table Num with a colum Num and put in it the numbers from 1
to 10 (or 100, or one million, however large quantity may get).

SELECT table.[item code], table.Des
FROM Num,

WHERE (((Num.Num)<=
.[quantity]))
ORDER BY table.[item code];

In the above I have used the table name "table" for the table you
showed.

Tested and working!

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Hello and thank you Tom Ellison,

I've tested => wonderful.

Thank you so much.
Thank you to have read until there.
 
Back
Top