autonumber field

  • Thread starter Thread starter angie
  • Start date Start date
It is better to create an autonumber field in the table the report is based
on. Simply add a filed to your table and make the datatype autonumber. Then
it is usually better to make it a primary key.
 
the report is generated by a complex query so i will either have to create a
new table with autonumbers to print the report or i would prefer to create an
autonumber field in the report. could i achieve something like that?

Ο χÏήστης "golfinray" έγγÏαψε:
 
Hi Angie,

If you need only a text box appearing nearby each record in your report,
showing the serial number of this record:

1. Add a text box in the detail section of your report
2. Set its control source to =1
3. In the Properties of this text box search for the Running Sum and change
it to Over All / Over Group.

Hope this helps,

GeorgeCY




Ο χÏήστης "angie" έγγÏαψε:
 
Back
Top