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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Return record number using Dlookup

Status
Not open for further replies.
rrhandle

rrhandle

Programmer
Dec 26, 2001
193
US
I am using a Dlookup, and it works. The problem is, I need to capture the row number.

Any suggestions?

 
Sort by date Sort by votes
Relational Databases have no row numbers. Do you perhaps have a field in the table that contains something equivalent to a row number?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
1K
serino
serino
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
918
JimStrand
JimStrand
supportsvc
  • Locked
  • Question
How to limit the number of records based on the quantity in a field? 1
Replies
8
Views
729
supportsvc
supportsvc
TrekBiker
  • Locked
  • Question
Select addresses using two criteria, one 'Like" 2
Replies
3
Views
576
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
543
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top