Auto number

K

Khartoum

Is it possible to add an autonumber to either a form or its query without
having a field in a table i.e like form below but adding the numbers 1,2,3
etc down the left to number the entries:

Date 1 Date 2 Number of Days sick
1. 1/12/07 8/12/07 7
2. 6/12/07 7/12/07 1

thanks John
 
A

Allen Browne

No. It is possible to add a subquery or domain aggregate function to
calculate a ranking, but it's quite inefficient, may not work correctly
without a suitable primary key, and doesn't work propertly at all if the
user filters or sorts the query differently.

You can number the rows in a form:
http://www.lebans.com/rownumber.htm
 
T

tedmi

Not possible in a form or query, but possible in a report. In the detail
section, put these text fields:
RowNum, Date1, Date2, etc.
In the Data Properties sheet for RowNum, put =1 as the control source, and
select "Over All" for the Running Sum
 
K

Khartoum

Thanks again Allen - don't you ever sleep!

Allen Browne said:
No. It is possible to add a subquery or domain aggregate function to
calculate a ranking, but it's quite inefficient, may not work correctly
without a suitable primary key, and doesn't work propertly at all if the
user filters or sorts the query differently.

You can number the rows in a form:
http://www.lebans.com/rownumber.htm
Click to expand...
 
Top