Hello.
In Access 2003 I have created a table with a single field Year and the values 80,81,81. I’m then using this table
to create a ‘cross-product’ with another table. That is, to repeat each row for each of the years 80, 81 and 82.
Is it possible to amend the SQL statement to include these values directly (without having to maintain a separate table)?
Thanks, Andy.
SELECT WideForm.id, Years.year, WideForm.sex, Choose([year]-79,[inc80],[inc81],[inc82]) AS inc
FROM WideForm, Years
ORDER BY WideForm.id, Years.year;
