record count from system

[jsrogol]

I'm trying to numbers records in a form and thought I could retreive the
system record count for that group of records but don't know how to do it. It
this possible or is there a better way to do this?

My table records dates and a different number of individuals for that date.
II need to count each record for that date and store the value in a text box
for that record. Obviously a auto number won't work over a group of records.
I know I can count records in a report but don't know how to do this in a
form to increment each record count. I thought that since the system did
record counts that would be a easy number to retreive if I can figure out how.

any advice?

Jsrogol

 

[Jeff Boyce]

I'm not quite clear on what you want to show.

Are you saying you want to count the number of records in a table? In the
entire table, or only those that match some selection criteria?

I'm not sure what you mean by "increment each record count", but you
generally wouldn't need to do that in Access, unless you are trying to store
a sequence number.

By the way, you mention using forms ... Access tables store data, Access
forms display data. Any data you need to "persist" needs to be stored in a
table.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[jsrogol]

Sorry,
I guess I didn't make myself very clear. I will be entering information into
a form that will need to have a incremental number for each record within
that group. Each group is based on a date entered. Ex-you select the date and
then enter people for that date. I need to have each record have a different
number that increases by 1. I have tried a number of ways to do this and it
works ok UNTIL you need to replace one of the names with a different name.
The code continues to increase the number by 1 even though you are only
changing a record and not adding a new record. When I am finished (after
changing) I loose a "number" and my listing is off. I thought there might
be a way to use the system record numbers (ex count that displays at the
bottom of the forms) somehow. I sort of gather that isn't possible.

jsrogol

 

[Jeff Boyce]

Why? As in "why do you need a unique number for each group/person?" I ask
because you may have decided that this approach is the only way you can ...
< fill in you business need here >. Again, I ask because, once we know what
problem you are trying to solve, we may be able to offer more appropriate
suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP