S Suncoast New member Local time Today, 02:35 Joined Oct 28, 2009 Messages 8 Oct 29, 2009 #1 is it possible to have a query that makes several records from a single record? Example: [TableA] ID:1 Quantity:3 Length:10 [QueryA] ID:1 Length:10 ID:1 Length:10 ID:1 Length:10
is it possible to have a query that makes several records from a single record? Example: [TableA] ID:1 Quantity:3 Length:10 [QueryA] ID:1 Length:10 ID:1 Length:10 ID:1 Length:10
N namliam The Mailman - AWF VIP Local time Today, 09:35 Joined Aug 11, 2003 Messages 11,695 Oct 29, 2009 #2 If you make a table with numbers 1,2,3 in it yes... Select id,length from yourtable,newtable where newtable.number <= Quantity
If you make a table with numbers 1,2,3 in it yes... Select id,length from yourtable,newtable where newtable.number <= Quantity