NUMBER LIST

P

Pam Coleman

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

tHANKS,
 
D

David Lloyd

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,
 
Top