Auto number

  • Thread starter Thread starter Khartoum
  • Start date Start date
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
 
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
 
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
 
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
 

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

Back
Top