How do I make total records count faster?

[JohnW]

Hi,

I have a continous form and I sum the number of records in a text box in the
footer. Control Source = Count([StockID])

This is a stock record of marine spares.

Some combo boxes on the form provide filtering criteria so that sotck item
details, location and number of Stock Lines (records) can be viewed.

There are about 32,000 records in total and each time it runs it takes
several seconds to present the result on screen.

I wondered if there was a faster function or some code that could speed this
up?

 

[Rick Brandt]

Hi,

I have a continous form and I sum the number of records in a text box
in the footer. Control Source = Count([StockID])

This is a stock record of marine spares.

Some combo boxes on the form provide filtering criteria so that sotck
item details, location and number of Stock Lines (records) can be
viewed.

There are about 32,000 records in total and each time it runs it takes
several seconds to present the result on screen.

I wondered if there was a faster function or some code that could
speed this up?

Do all of the fields you are filtering on have indexes on them? They should.

 

[JohnW]

No they didn't. Its much faster now.

Do you know a way to have an egg timer showing during the (shorter) waiting
period. I can do this in VBA but don't know how when it is a sum like this.
--
John Whyte

Hi,

I have a continous form and I sum the number of records in a text box
in the footer. Control Source = Count([StockID])

This is a stock record of marine spares.

Some combo boxes on the form provide filtering criteria so that sotck
item details, location and number of Stock Lines (records) can be
viewed.

There are about 32,000 records in total and each time it runs it takes
several seconds to present the result on screen.

I wondered if there was a faster function or some code that could
speed this up?

Do all of the fields you are filtering on have indexes on them? They should.