Max(.)+1 results in NaN

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lupe - 26 Jan 2007 09:25 GMT

Hey there,

I've got an Infopath form linked to an Access DB. When I start a new
form I'd like one of the text boxes to be auto-filled with the next
sequential number for a field.

I've tried setting the default value to max(fieldname) + 1" but that
result's in NaN. and if i just try "max(fieldname)" the box is blank,
so i'm not sure it's querying the db?

Am I doing something wrong or is there another way to get incrementing
numbers in Infopath?

Any advice would be greatly appreciated,
T

Reply to this Message

Jesper - 26 Jan 2007 11:43 GMT

Hi Lupe!

Take a look at the link below - it solved the same problem for me.

http://www.infopathdev.com/howto/tutorials/default.aspx?i=d663d7df90e94e65abb026
32966e8127

Best regards,
Jesper

Reply to this Message

Lupe - 26 Jan 2007 13:19 GMT

Thanks for the reply Jesper!

I'm fairly new to formulas and i'm having a bit of trouble with that
one.

"count(../preceding-sibling::my:Row) + 1"

if my Table was named "BookIn" and the field I would like to auto-fill
was "RefNum" which fields would i replace in that formula?

I apologise for my ignorance :)

> Hi Lupe!
>
[quoted text clipped - 4 lines]
> Best regards,
> Jesper

Reply to this Message