Gossamer Forum
Home : General : Databases and SQL :

Want to show x times the same record

Quote Reply
Want to show x times the same record
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 forcedCrazy to use it)-
Subject Author Views Date
Thread Want to show x times the same record Michie 4878 Aug 27, 2002, 3:04 AM
Thread Re: [Michie] Want to show x times the same record
Stealth 4643 Aug 27, 2002, 8:11 AM
Post Re: [Stealth] Want to show x times the same record
Michie 4584 Aug 27, 2002, 10:05 AM