Exclude first record in select query, w/out using SQL. (1 Viewer)

M

mgrady11

New member

Local time

Today, 11:03

Joined

Jan 14, 2020

Messages

1

• Jan 14, 2020

• #1

I am trying to exclude the first record of a select query without using SQL. I am ok with a working solution that takes the long way around, even if multiple queries are necessary.

Do you have any suggestions on how to accomplish this?

 

theDBguy

I’m here to help

Staff member

Local time

Today, 11:03

Joined

Oct 29, 2018

Messages

21,467

• Jan 14, 2020

• #2

Hi. Welcome to AWF! Just curious what you mean by without using SQL because a query uses SQL.

 

isladogs

MVP / VIP

Local time

Today, 19:03

Joined

Jan 14, 2017

Messages

18,211

• Jan 14, 2020

• #3

I think you mean without using VBA.

First create a query to obtain the record you want to exclude
SELECT TOP 1 * FROM TableName ORDER BY YourSortFieldName
Now save that as e.g. qryTop1

Now create a new unmatched query using the wizard linking the table and qryTop1
That will get all records in the table not in qryTop1

Note - it would be possible to do both steps in one query but doing so will be more complex

 

Last edited: Jan 14, 2020

jdraw

Super Moderator

Staff member

Local time

Today, 14:03

Joined

Jan 23, 2006

Messages

15,378

• Jan 14, 2020

• #4

mgrady11,
Further to the responses so far, could you tell us a little about your query and what's special about "the first record"? There may be some other options if we knew the underlying issue.
Good luck with your project.