Hello - I want to create a set of 6 records in an Access 2003(2000) database. I can create a record thus (SQL from append query):
INSERT INTO tblTest ( AssessmentID, AssessmentNumber, Hazard, [q(y/n)], [c(y/n)], info, moreinfo )
SELECT [Input AssNo] & [Input Hazard] AS AssID, [Input AssNo] AS AssNo, [Input Hazard] AS Haz, 'Y' AS q, 'N' AS c, 'lots' AS Inf, 'Lotsmore' AS morinf;
[Input Hazard] has 6 values (e.g. A, B, C, D, E, F) for each value of Input AssNo - which is a number e.g. 1339?
A, B, C, D, E, F are always the same so they can be "hard coded".
How do I get a query to loop and create 6 records please?