DMIN returning max value, and DMAX returning min value

[AB1984]

I'm stumped on this one.


I have a table that has a sharepoint table as its source. When I attempt to use the DMIN/DMAX function in VBA, they both return the opposing value. It's only for this table though, all other local tables it works fine for.
I know I could just take it as given that DMIN's giving max and vice versa and use that in my code, the worry is that it'll eventually just sort itself out and I'll have to change my code to deal with it.

Any suggestions as to what the problem could be?

Cheers!

[CJ_London]

what is your actual code for dmin, dmax?

what is it returning? a number? date? text?

provide some examples of what you expect and what you get

[NTC]

sanity check with an aggregate query to compare with....

[AB1984]

If anyone else had this problem:
I seemed to fix the problem by ordering by the number I was dminning and dmaxing ascending.