Exclude TOP N records from query

[gemadan96]

I have a table that includes a date/time field. I want to query that table and show all but the TOP N records. Since the number of records will always be changing I cant do it using the BOTTOM N records.

Any suggestions on how I can do this are appreciated.

[burrina]

First Create a query to get the top N values. Create a Totals query then a Union query for the final result. Someone else may know of an easier way.


HTH

[gemadan96]

Thanks. Figured it out using this link: http://www.btabdevelopment.com/ts/tbl2exclude

[burrina]

Glad you got it sorted out. Good Luck With Your Project!

[orange]

I like Bob's way of doing the exclude also.

Here's another general approach using a subquery :

Select * from YourTable where YourDateFieldInvolved
Not In (Select Top N X.YourDateField from YourTable as X)

Note: There is no Bottom N. You have to use Order By in your SQL either ASCending (the deault) or DESCending to get the "lowest" or "highest" N values.