Output multiple records from one record using a query
Posted on 2003-11-17
Is it possible to output more than one record from each record read into a query?
ie) if I have an append query that reads tableA, I want to append 4 records to tableB from each record in tableA using different fields from table A
If not in a query is there another way....keeping in mind I am pretty new to all this?
This is the SQL view of my query so far....
INSERT INTO [Tee Time Analysis Table] ( [Date], [Tee Time], [Member No], [Member Name], Comments, [Member Type] )
SELECT [Tee Times].[Todays date], [Tee Times]., [Tee Times].[600m1no], [Tee Times].[600m1], [Tee Times].[600comments], Mid([600m1no],2,1) AS Expr1
FROM [Tee Times]
WHERE ((([Tee Times].[600m1no]) Is Not Null));
I would like the same info for 600m2no, 600m3no and 600m4no