Query to show all records except the smallest

Boomshank

Registered User.
Local time
Today, 19:01
Joined
Feb 20, 2009
Messages
29
Hello,

I know i can create a query that displays the records with a minimum figure but how can i get my query to show all records but the ones with the minimum figure.

My Query has the following fields

Run
PayrollName
Output
Timestamp
Boxes

as an example, run 1 may have three payrolls, one of the payrolls may have run the same output three times at different intervals, i want to show all but the earliest one.

Can this be done?
 
2 queries, or a sub query maybe.
1st query just pull Minoftimestamp

2nd query pull the details you need, include first query so that criteria in timestamp is
> [MinofTimestamp]

Brian
 

Users who are viewing this thread

Back
Top Bottom