record numbers

[eb1mom]

User is part of precomputer employees. He keep 25 folders
numbered 1-25. With one complaint record in each folder, as
complaints were taken care of he moved them to other
folders grouped by date. I tried an inactive check box and
query to only show active records. Still the record count
number didn't match record number. Is it possible to create
a record count field in table so it would appear on form?
Thanks

 

[Bob]

There's already a record count function built into Access.
It appears next to the navigation buttons at the bottom of
each form. If you want to see a specific record count
based on some type of criteria you'll have to use DCount
if I'm understanding what you're saying.

 

[Jeff Boyce]

Record count (how many) and record number (a number assigned to a row) are
unrelated.

In your example, it sounds like this user would be trying to "re-use" a
record number, after the complaint was "moved ... to other folders".
Perhaps a record number isn't the most suitable way to identify the row?

 

[eb1mom]

Reusing the record number is exactly what he is doing. Yes
I know this is a VERY bad thing to do. I was just hoping
for a way to display the record count on the form. Then it
would appear to him that numbers matched. This is a picky
little problem but, important to him. I am just trying to
make him happy until retirement. If anyone has a suggestion
I would appreciate it.

 

[Jeff Boyce]

?!Early retirement?! (yours, or his?)

As another respondent pointed out, tell him Access doesn't work that way.
Point out that if he is standing in line at the checkout at the grocery
store, WHO he is (a "record number") and WHERE he is (his record "count")
are unrelated.

Perhaps if you can have him explain what he uses the information for, there
could be another approach that would satisfy his underlying business need,
without requiring something that Access doesn't do.

 

[eb1mom]

I wish I was the one who could retire. I will try your
check out line explanation. The system is his and his alone
and there is no rhyme nor reason for most of his incredibly
convoluted record sytsem. Thanks for your input.