NUMBER LIST

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

IS THERE A WAY TO RUN A QUERY THAT WHEN IT COMES BACK THE LINES WILL BE
NUMBERED (1,2,3,4.....ETC.)?

tHANKS,
 
Pam:

The "PlusOne" function in the following link should give you what you need.
It is used for a different purpose, but if you add a field to your query
similar to this (removed the MOD 5 portion), you will end up with a numbered
list.

http://www.mvps.org/access/queries/qry0006.htm

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


IS THERE A WAY TO RUN A QUERY THAT WHEN IT COMES BACK THE LINES WILL BE
NUMBERED (1,2,3,4.....ETC.)?

tHANKS,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ID numbering secquence 1
Creating a Sequential Record ID number with a make-table 7
Create random list - dublicates are okay but not right after each other 2
SELECT SQL, can you have two 3
Ranking by Query 4
Counting multiple memberships 1
Record number - Easy 1
Percentiles in Excel 2

Back
Top