Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show all matches except the first

Status
Not open for further replies.
RobPotts

RobPotts

Technical User
Aug 5, 2002
232
US
Hi,

I would like to create a subfor which shows all the records for a certain item except the first. Is this possible.

Thanks in advance
Rob!
 
Sort by date Sort by votes
If you have some kind of number, key, quantity etc on which the recordset is sorted so that the first record is either the lowest or highest, you could set a criteria equal to all except Max(WhateverNumber) or Min(WhateverNumber).
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
231
atadbitslow
atadbitslow
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
538
Moss100
Moss100
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
252
LondonJohn
LondonJohn
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
100
dhookom
dhookom
Trob70
  • Locked
  • Question
There is no object in this control 1
Replies
9
Views
407
Trob70
Trob70

Part and Inventory Search

Sponsor

Back
Top