I've taken over a database written in Access '97 so it's quite old and I don't want to rewrite the whole thing.
I have a query as the record source for a report like this:
Which gives me the first value.
Now I need to reverse that and create a query that gives me all the other results. Basically everything except the top row.
Any ideas?
I have a query as the record source for a report like this:
Code:
SELECT TOP 1 ID1Child5.ID, ID1Child5.CODE1, ID1Child5.CODE2, ID1Child5.CHARGE, ID1Child5.DEFAULTS FROM ID1Child5 WHERE (((ID1Child5.ID)=[Forms]![ID1MainForm_0]![ID])) ORDER BY ID1Child5.DEFAULTS;
Which gives me the first value.
Now I need to reverse that and create a query that gives me all the other results. Basically everything except the top row.
Any ideas?