Different record no.

[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

 

[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

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

Perhaps there's a filter active

 

[Guest]

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

Steve

 

[Ray]

Gijs,

Thanks for your advice. You are right there is a query in record source.

Ray

 

[Ray]

Steve,

Thanks for your good suggestion to find out the duplicates.

Ray

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