DMax is returning an "#Error" as I try to use it to find the largest "Acqusition Number" in the table "ACQ FY08":
In the text box "Acquisition Number", on the data tab under Default Value I've entered --
=DMax("Acquistion Number","ACQ FY08")+1
I am also getting an Access error message: "Syntax error (missing operator) in query expression 'Max(Acqusition Number)'."
A past consultant set up this database with a "front end" ( gui file) and a "back end" ( .data file). Could that be causing a problem with the functioning of DMax? How do I get this to work?
In the text box "Acquisition Number", on the data tab under Default Value I've entered --
=DMax("Acquistion Number","ACQ FY08")+1
I am also getting an Access error message: "Syntax error (missing operator) in query expression 'Max(Acqusition Number)'."
A past consultant set up this database with a "front end" ( gui file) and a "back end" ( .data file). Could that be causing a problem with the functioning of DMax? How do I get this to work?