Disappearing - Reappearing Records?....

[Sherri]

I've never seen this happen before - but if you have
please give me a solution.

I'm running Access2000 - database file shared on the
network. I have approximately 10 users entering data.
When I would sort my table on SSN Access showed only
45,000 records. When I would sort my table on the
autocount field Access showed 170,000 records.

The 170,000 records is where I should be. My question is -
how does a record get generated without the link field of
SSN?

Sherri

 

[Tim Ferguson]

When I would sort my table on SSN Access showed only
45,000 records. When I would sort my table on the
autocount field Access showed 170,000 records.

This does not make a lot of sense: what are you doing to count the records?

Method 1: open the table in datasheet mode and look at the video buttons at
the bottom -- this will not change in response to sort order.

Method 2: use a COUNT(*) query: apart from the fact that this is not
sortable, it would not change even if it were.

Method 3: using COUNT(SSN) or COUNT(IDNumber) in a query: these are likely
to be different because of the handling of NULL values. If you have a large
number of missing SSN numbers, the query will obviously return a smaller
number. I am not quite sure what happened to COUNT DISTINCT(SomeColumn)

Hope that helps

Tim F