Populate a field with a sequence number based on two criteria

[moore020]

I am trying to get the max of an integer field if the ProjectNumber field is equal to the ProjectNumber field in the current record. I have used code similar to the one below before but it was on a date field, then add one.

Me.RevisionNumber = Nz(DMax("[RevisionNumber]", "dbo_ProposalLog", "[ProjectNumber] =" & Me.ProjectNumber), 0) + 1

The ProjectNumber field is a text field.

 

[GinaWhipp]

Hmm, maybe this will help...

Another post on Sequential Numbering...
http://regina-whipp.com/blog/?p=704

 

[moore020]

I think I am really close with the code that I posted but I keep getting a missing operator error.

 

[moore020]

Scratch the idea of using multiple criteria, I cant get the code line that I posted to work. I am getting an operator error. I added brackets before and after ProjectNumber but it is still erroring out.

 

[GinaWhipp]

Is ProjectNumber Text or Numeric? OR have you just moved on...

 

[moore020]

This is the code that worked for me. It had to do with Project Number being a string instead of a date or number.

"[ProjectNumber] = '" & Me.[ProjectNumber] & "'")

 

[GinaWhipp]

Yep, that is why I asked, I thought that might be the case...