autonumber field

G

golfinray

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.
 
A

angie

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" έγγÏαψε:
 
G

George

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" έγγÏαψε:
 

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

Adding data to MS Access from csv file 0
Autonumber field in Excel that behaves the same as Access 0
Unable to display values in 2nd list box from 1st list box selection 2
Multiple Text Fields - i.e. "Figures" and "Tables" 1
Using a text box to create a report 1
Make Table Query and Autonumber Fields 5
Display Dynamic # of Rows in SubReport 0
autonumber queestion 3

Top