Link to home
Start Free TrialLog in
Avatar of Harsh Kumar
Harsh KumarFlag for Denmark

asked on

ACCESS / VBA - Count of Rows in Table

Hi is there a way to count the rows in a table i have tried various ways but no luck without it taking more then 5 min.

The table is around 260000 records and increasing in the future...

please advise
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Harsh Kumar

ASKER

Thx guys, i did try Dcount aswell but for some reason its working now...
Glad it worked eventually. Pleased to help :)