dmax not working in 2003

[Mandango]

I have DMax and Dmin in a query and it works in Access XP 2002 but not in
2003...any suggestions?

 

[vanderghast]

Problem of Missing Reference? If so,

? Trim(" abc ")

won't work either.


Vanderghast, Access MVP

 

[Mandango]

The message I get is Undefined function 'DMax' in expression.

 

[Gina Whipp]

Mandango,

What References do you have set? Did you try... ? Trim(" abc ") to
see if that works? Also, providing the code snippet might help us detect
why you get that message.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[vanderghast]

DMax may not work in 2003 while the same expression worked in 2002 if you
have a Missing Reference problem, EVEN if the missing reference has nothing
to do with DMax.

To be sure if it is NOT the case of a missing reference, try, in the
Immediate Debug Window the following simple statement:

? Trim(" abc ")


Followed by a return. If that ALSO produces an error, then it is very likely
that you have a Missing Reference problem: In the VBE menu, under Tools,
chose References.... You should get a very long list of possible
references, but among those which are selected with a check mark, look if
their description start with the word MISSING. If so, try to uncheck that
reference (or try to find its real 'Location" on that particular pc, if it
is a reference you really need). Once this is done, try again your original
expression.



Sure, DMax may also have stop working if you have ALSO modified (you, by
yourself, or indirectly with name auto correction) fields names or table
names: the automatic name change is likely to miss the names appearing in
STRINGs, as it is the case for DMax arguments.




Vanderghast, Access MVP