Different record no.

R

Ray

I have a input form linked to a table and found the total no of records on
the bottom bar is different from that of table. Can someone advise an
effective way to find out the different records since there are over 20k
records.

Thanks,

Ray
 
G

Gijs Beukenoot

Ray schreef :
I have a input form linked to a table and found the total no of records on
the bottom bar is different from that of table. Can someone advise an
effective way to find out the different records since there are over 20k
records.

Thanks,

Ray
Click to expand...

Perhaps the form is based on a query that doesn't return all records

Perhaps there's a filter active
 
S

Steve Murphy (Kuwait in Army**US)

Try running a find duplicates query see if the numbers add up.

Steve
 
R

Ray

Steve,

Thanks for your good suggestion to find out the duplicates.

Ray

"Steve Murphy (Kuwait in Army**US)"
 
Top