Dmax()

[Super Suarez]

Hi Guys,

I'm using Dmax() to return a max number in a field which I then want to inc by 1 for a new record. Dmax is returning 999. I believe Dmax therefore thinks it's a text field. So where do I change this to a number field?

 

[namliam]

how about DMax just finding the maximum value to be 999 ?

If you do have 1000 numbers and it is still returning 999 as the max then yes that is because of the text field "issue". If your field is a number field that is a text field the best way to solve this is by changing the field type to double or somesort alike.

If you cant do that you can try wrapping the field by CDbl or CInt to change it to number.

 

[Super Suarez]

The field was indeed setup as a text field and I didn't realise you had to open up the table and go into the design section and change the type there to Number.

Thanks for the reply