DCount overflow

[scottian]

I'm getting an overflow using the DCount function. Is there anyway to overcome this?

I'm thinking using a dataset might work

"My God! It's full of stars...

 

[dhookom]

I have never gotten an overflow from a DCount(). Maybe if you told us what you are attempting to accomplish...

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[scottian]

d = DCount("[FIELD1]", "table1", "[Index] is null")

there are over 87,000 records in the table and i ned to update the null field with an incrementing number which will increase when a value is met in a certain field

"My God! It's full of stars...

 

[scottian]

all i need is a pointer to how adatasets work and are created and i could probably work it out from there

"My God! It's full of stars...

 

[dhookom]

What is "d"? Did you Dim this as an Integer? If so, change it to Long.

We still don't know what you are attempting to accomplish and why.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[scottian]

thank you , so much.

it worked

"My God! It's full of stars...