Select Query

[Fipp]

I have created a select query that will locate records
that meet certain requirements.

Within this query there is a field called "psn" this
field is a sequentially numbered field.

I am now trying to create a query that will give me the
record with the next psn# iepsn+1) The query should be
based off the criteria in the first query. It will
essentially give me the records proceeding the select
query. I hope that makes sense.

Thanks for your help.

Fipp

 

[Marty]

Unless you are executing the query which looks for a
specific "PSN" in the criteria (and it dose not sound like
you are however you didn't specify that) then the answer
is, you cannot do what you're asking with just one Query.
You would have to make a query of the query. To run these
two queries I'd create a macro then put a button on a
Form. If you do not know how to do this please let me
know and I'll be happy to help you.

On the off chance you are specifing the "PSN" in the
criteria the to that criteria add: AND PSN + 1