I need to identify a certain record based on it's position in the query
result.

IE:  I run a query and I get 6 hits.

I need to be able to identify RECNO 3 and RECNO 6.  Not the record
number from the main data source, but the record number of how they
appear in the query result.

any ideas?

thanks,
gary

Gary Mead
Software Trainer
DCCCD Service Center
(xxx) xxx-xxxx
gmead@d...

Run a make query, that should do the job.
Tom M

-----Original Message-----
From: gmead@d... [mailto:gmead@d...]
Sent: Thursday, August 22, 2002 8:37 PM
To: Access
Subject: [access] Query Question


I need to identify a certain record based on it's position
in the query
result.

IE:  I run a query and I get 6 hits.

I need to be able to identify RECNO 3 and RECNO 6.  Not the
record
number from the main data source, but the record number of
how they
appear in the query result.

any ideas?

thanks,
gary

Gary Mead
Software Trainer
DCCCD Service Center
(xxx) xxx-xxxx
gmead@d...
---
Change your mail options at http://p2p.wrox.com/manager.asp
or