How to make display multiple row of a table according to quantity (1 Viewer)

[Majid Azimi]

Hello guys
how can I Repeat records according to a quantity field in table of access?
for example I have a table with 2 columns " name" and "quantity" like below:
in "name" column I have " jack " value and in "quantity" column I have "5" value
and I want repeat "jack" value 5 times in table

 

[ebs17]

SELECT
   D.XName,
   D.Quantity
FROM
   tblData AS D,
   T999 AS T
WHERE
   T.I < D.Quantity

T999 would have to be created once. It is an auxiliary table with a field I (Long) containing the numbers from 0 to 999 consecutively. Such a table can be used in many ways.

 

[mike60smart]

No understanding what you are trying to do.

What is the purpose of your Db?