Dmax more than one field

[gmatriix]

Hello All,

I just wondering if there is any way to Dmax more than one field? I found something and tried it but it does not seem to work.

Text13 = 10
Text15 = 5

I expected to get a result of just 10 but didn't

Dim Junk As Variant

Junk = DMax("[Text13] & ', ' & [Text15]", "Test")

MsgBox Junk

Any Ideas?

 

[pr2-eugin]

gmatriix, not sure if that is a valid operation.. As the code would read and look for a field called Text13, Text15..

I think to achieve what you want, a Custom function would come in handy here..

However.. The real question is Why do you wan this unconventional Max function usage?

 

[gmatriix]

Well,

For Example
I have 3 measurement in 3 different fields. I need to find out of the 3 which one is the max and which one is the min.

It is set up this way because I need 3 readings per part. I understand that this could have been set up differently but due to the reporting software we are using it has to be set up this way.

So anyways....Im just trying to find out...out of the 3 fields which one is the max and min... hope this helps in understand what I need to do.

I suppose I could append the records to a table and max/min there???

thanks

 

[pr2-eugin]

You really should think about redesigning your Table structure.. As you can make this so much easier if they are stored as Row values than column.. Anyway, See if the method described by Allen Browne would give you some pointers..

 

[gmatriix]

Thanks, that looks good. I appended each reading in a table and from there I can do my max min....

Thanks again buddy!

 

[pr2-eugin]

Happy to help..