Hello!
I've have created this query in MSSQL:
SELECT gr.year, gr.col1, s.col1 AS prevyearcol1
FROM table AS gr
LEFT JOIN table AS s ON s.year = gr.year-1
ORDER BY gr.year
Access 2007 crashes when running this. Is it possible to get this result by typing it in another way?
I simply want each record to have a value from the record with the previous year.
I've have created this query in MSSQL:
SELECT gr.year, gr.col1, s.col1 AS prevyearcol1
FROM table AS gr
LEFT JOIN table AS s ON s.year = gr.year-1
ORDER BY gr.year
Access 2007 crashes when running this. Is it possible to get this result by typing it in another way?
I simply want each record to have a value from the record with the previous year.