HELP PLEASE - Record numbers

B

baz

Please posst response as email used is bogus to prevent spam - Thank
you

I am using Access 2002

I have a database of books.

Although each BOOK_ID has a number I would like to include the record
Number in my report

I just need to know how to put it in. I have tried various things on
the FORM but can't get it.

Any help would be appreciated. I have to believe it is simple but I'm
not getting it!

Thank you in advance for your help.
 
F

fredg

Please posst response as email used is bogus to prevent spam - Thank
you

I am using Access 2002

I have a database of books.

Although each BOOK_ID has a number I would like to include the record
Number in my report

I just need to know how to put it in. I have tried various things on
the FORM but can't get it.

Any help would be appreciated. I have to believe it is simple but I'm
not getting it!

Thank you in advance for your help.
Click to expand...


There is no such thing as a 'Record Number" inherit in an Access
record. Access records are just like pebbles in a bucket ... all
mixed up.

If you just wish to number the books in a report, i.e.
1 Gone with the Wind
2 The Red Badge of Courage
3 etc....

It's quite easy to apply a number to the record when printing a
report, but today's record #25 may be well tomorrows record # 16 and
will have no meaning other than a number on a piece of paper.

Add an unbound control to the report.
Set it's control source to:
=1
Set it's Running Sum property to
Over All

Done.
 
Top