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!

Showing the number for each row

Status
Not open for further replies.
ciarra41

ciarra41

Technical User
Sep 11, 2006
116
US
Hi,

How can I show the number in a separate field of each row in a query? Exp: 1. 2. 3. 4. Using an expression not from the table.

thanks
 
Sort by date Sort by votes
Here is an example from the FAQs:
How do you really put an incremental value in your query?
faq701-1155
There are others, as far as I recall.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Select X of each variation of a field 1
Replies
8
Views
700
rashmibala
R
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
917
dhookom
dhookom
mhshane
  • Question
Is this the best way to do this query?
Replies
3
Views
150
Chriss Miller
C
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
1K
serino
serino
JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
5K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top