Query generates results?

[Hanss]

Hi,

I am wondering if there is anyway to do this with an access query:

I have table1 with two fields and data:

Temp: Count:
15 2


20 3

I would like a query that generates the following results:

Results:
15
15
20
20
20

I would appreciate any direction.

[Minty]

You can but the easiest way to achieve this you would need a numbers table.

SELECT tb_Test1.Temp
FROM tb_Test1, tb_Numbers
WHERE (((tb_Numbers.id)<=[recCount]))
ORDER BY tb_Test1.Temp;

Numbers Table			tb_test1			Result
ID	RecNo		Temp	RecCount		Temp
1	1		15	2		15
2	1		20	3		15
3	1					20
4	1					20
5	1					20
6	1
7	1
8	1
9	1
10	1
11	1
12	1
13	1
14	1
15	1
16	1
17	1
18	1
19	1
20	1

[Hanss]

Thank you VERY much for this simple method!!!