Totals in a report

[JR]

I have a table with muiltple fields including a ID field which is an
auto-number field which counts the number of items in the table. How do I get
the last number in the ID field to show as total items in a report? I know it
must be a simple fix but I am new to this...

 

[Jeff Boyce]

I'm confused ...

An Access "autonumber" data type field doesn't "count" anything. Perhaps
you are using this term differently?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[JR]

I am using the autonumber to register how many items are entered into the
table which in return doubles as a item counter for the table. Maybe this is
not how it should be used but it seemed like it would work.

 

[Jeff Boyce]

It doesn't. You might want it to, and you wouldn't be the first person to
expect it to, but it doesn't and it won't and if you build functionality
around expecting it to, you will get wrong data at some point.

Autonumbers in Access are intended as unique row identifiers, nothing more.

If you need to know how many records are in a table, use a query. You can
convert a Select query to a Totals query and use "Count" on the Autonumber
field to find out how many records there are.

Good Luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP