Dmax - type mismatch error

[Gina Maylone]

Hello all!



Pulling my hair out, I need to create a sequential number to order payments the way they are entered, long story. My table is ScheduleT (part of an amortization app) both LoanID and PaymentNumber are numeric fields, my code:

Me.Sequence = Nz(DMax("[Sequence]", "schedulet", "LoanID=" & Forms!LoanF!LoanID), 0) And ("paymentnumber = " & Forms![LoanF]![ScheduleF].Form![PaymentNumber]) + 1

If I remove the second criteria it works fine, except it numbers all of the remaining payments, which I don't want. Does anyone see a glaring error with my quotes or something? I'm getting "type mismatch" with the whole line highlighted.

Thanks in advance!

[pbaldy]

The second criteria isn't in the DMax. More like:

Nz(DMax("[Sequence]", "schedulet", "LoanID=" & Forms!LoanF!LoanID & " And paymentnumber = " & Forms![LoanF]![ScheduleF].Form![PaymentNumber]), 0)

[Gina Maylone]

The second criteria isn't in the DMax. More like:

Nz(DMax("[Sequence]", "schedulet", "LoanID=" & Forms!LoanF!LoanID & " And paymentnumber = " & Forms![LoanF]![ScheduleF].Form![PaymentNumber]), 0)

THANK YOU PBaldy - worked like a charm!

[pbaldy]

Happy to help!