Overflow Error? 1

[alr0]

Hi All,

I am trying to gather some stats on the current work being done and have the following statement to get the lowest cliam7 number in the table WkDt. When the assignment statement runs, it errors out with a dialogue box that says,"Overflow".

Dim StNo As integer
StNo = DMin("claim7", "WkDt")

The statement runs in the immediate window and gets the right answer. I did not see anything useful in the help or the knowledge base. This is running on Access 03 on Win xp pro.

Anyone know what's going on?

Thanks,

alr



_____________________________________
If a large part of intelligence is the ability to generalize, it is ironic that a large part of what we call wisdom is the ability not to generalize.

 

[abaldwin]

Try changing from an integer to a double and see what happens.

I.E.

Dim StNo As integer
StNo = DMin("claim7", "WkDt")

Change to

Dim StNo as double
stno = Dmin("claim7", "WkDt")




Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[alr0]

(Slaps self on head)

Of Course!

I did make it long rather than double but my 1-8 sample is padded to 1000001, so of course there was overflow.

Thanks

alr

_____________________________________
If a large part of intelligence is the ability to generalize, it is ironic that a large part of what we call wisdom is the ability not to generalize.

 

[abaldwin]

Your welcome. Sometimes it just takes another set of eyes. I run into that all the time.


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.