SELECT all but the top row

grades

Registered User.
Local time
Yesterday, 16:21
Joined
Apr 19, 2012
Messages
44
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:

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?
 
Add an additional bit to the WHERE clause
...AND Defaults NOT IN (Select Min(Defaults) from tblID1Child)...
 

Users who are viewing this thread

Back
Top Bottom