Dmax in a Domin

[Guest]

Hi all,
My table contains : Field1 Field2
11 b
13 bb
20 cc
26 c
How can I get maximum number in field1 in range 10 - 20 via code(Dmax)?
any help would be appreciate

 

[Douglas J. Steele]

=DMax("[Field1]", "[MyTable]", "[Field1] BETWEEN 10 AND 20")

 

[Guest]

Hi Douglas,
Thank you for comment but, I receive an Error :
"Data type mismatch in criteria expression. (Error 3464)"
Bijan

=DMax("[Field1]", "[MyTable]", "[Field1] BETWEEN 10 AND 20")

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi all,
My table contains : Field1 Field2
11 b
13 bb
20 cc
26 c
How can I get maximum number in field1 in range 10 - 20 via code(Dmax)?
any help would be appreciate

 

[Jason Lepack]

What data type is Field1? Is it text?

Hi Douglas,
Thank you for comment but, I receive an Error :
"Data type mismatch in criteria expression. (Error 3464)"
Bijan

=DMax("[Field1]", "[MyTable]", "[Field1] BETWEEN 10 AND 20")

 

[Douglas J. Steele]

As Jason asks, is Field1 a text field? If so, then you need:

=DMax("[Field1]", "[MyTable]", "[Field1] BETWEEN '10' AND '20'")

Of course, you may run into problems with that: using text, 19999999 is
between 10 and 20.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi Douglas,
Thank you for comment but, I receive an Error :
"Data type mismatch in criteria expression. (Error 3464)"
Bijan

=DMax("[Field1]", "[MyTable]", "[Field1] BETWEEN 10 AND 20")

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi all,
My table contains : Field1 Field2
11 b
13 bb
20 cc
26 c
How can I get maximum number in field1 in range 10 - 20 via
code(Dmax)?
any help would be appreciate