Syntax and DMax issue

[Guest]

I have a field comprised of serial nos. For those rare equipment items that
do not have a serial number, they are assigned the following artificial
serial number: NoSerial#. I would like there to be an unbound object that
displays the last artificial serial number assigned so that the user knows
what the next sequential number is. I figure the simplest way to do this is
by using the DMax function in the control source of the text object.

If I do the code below, it works fine and returns the value "NoSerial1"
But how do I write it so the it returns the max value of the criteria LIKE
"NoSerial*", or can I?

=DMax("[SerialNo]","tblEquipment","[SerialNo] = 'NoSerial1' ")

Thanks,
AG

 

[Douglas J. Steele]

=DMax("[SerialNo]","tblEquipment","[SerialNo] Like 'NoSerial*' ")

 

[Guest]

I tried that, it didn't work for some reason.

=DMax("[SerialNo]","tblEquipment","[SerialNo] Like 'NoSerial*' ")


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have a field comprised of serial nos. For those rare equipment items
that
do not have a serial number, they are assigned the following artificial
serial number: NoSerial#. I would like there to be an unbound object that
displays the last artificial serial number assigned so that the user knows
what the next sequential number is. I figure the simplest way to do this
is
by using the DMax function in the control source of the text object.

If I do the code below, it works fine and returns the value "NoSerial1"
But how do I write it so the it returns the max value of the criteria LIKE
"NoSerial*", or can I?

=DMax("[SerialNo]","tblEquipment","[SerialNo] = 'NoSerial1' ")

Thanks,
AG

 

[Douglas J. Steele]

What does "didn't work" mean in this context? You got an error? If so, what
was the error? You didn't get an error, but you didn't get the answer you
expected? What answer did you get, and what did you expect to get?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I tried that, it didn't work for some reason.

=DMax("[SerialNo]","tblEquipment","[SerialNo] Like 'NoSerial*' ")


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have a field comprised of serial nos. For those rare equipment items
that
do not have a serial number, they are assigned the following artificial
serial number: NoSerial#. I would like there to be an unbound object
that
displays the last artificial serial number assigned so that the user
knows
what the next sequential number is. I figure the simplest way to do
this
is
by using the DMax function in the control source of the text object.

If I do the code below, it works fine and returns the value "NoSerial1"
But how do I write it so the it returns the max value of the criteria
LIKE
"NoSerial*", or can I?

=DMax("[SerialNo]","tblEquipment","[SerialNo] = 'NoSerial1' ")

Thanks,
AG