Hi all,

I have a problem, Im making a database and i vave the following in a table:

NAME - NUMBER
A - 1
B - 3
c - 2
I'm making etiket stickers, but I want the followiong to be printed:
A
B
B
B
C
C

So I need to have a query that produces the above result, else i cant print enough stickers.
I can get ABC, but nog enough of them.



Please Help me
-Im running the database on MS ACCES(I know not THE database, but I'm forced to use it)-

What front-end scripting language (like VBScript, ASP, Cold Fusion, etc.) are you using?

There could be different ways of displaying the records through the front-end scripting code than within the SQL Statement.
========================================
Buh Bye!

Cheers,
Me

I use MSAcces, and the Visual thats included Visual basic 6...

I think I need something like a recordset and a loop that loops untill the number from the datavase, but i cant get it working