Dmax problem

[Simon]

I am trying to use DMax("WarrantyClaimID", "tblWarranty") + 1 to
produce the warranty Claim Number

It work fine until by working out the number until it has to generate
11 as it just alwasy seems to put 10.

Even if i manualy change it to 11 then save it and try it again it
should put 12 but instead it puts 10 there again even thought it have
alread been use.


Any one help me with y it will not work out numbers larger than 10

Thanks

 

[Allen Browne]

Answered in another group where you posted this question.