DMax with more criterias

[omaggi]

Hi Everybody.
I'm trying to build a Dmax function that include more criteria. But I have some problems.

Here I post the 2 DMax function:

DMax("age", "data", "[id_name] = " & Me.ccName)
DMax("age", "data", "[id_address] = " & Me.ccAddress)

I need that the 2 are together so I will receive as output the record the the max age with these 2 criterias...

Thanks for any help.

Greetings.

 

[boblarson]

If id_name and id_address are text fields:

DMax("age", "data", "[id_name] = " & Chr(34) & Me.ccName & Chr(34) & " And [id_address] = " & Chr(34) &  Me.ccAddress & Chr(34))

 

[omaggi]

Thanks, I tried but doesnt work...

If I write the 2 functions DMax separate, works good but I need absolutly to concat the 2 functions together...If not I don't have the right value in output...

Any other suggestions?

 

[boblarson]

Well, the code I showed is correct. I looked back at it just in case. Can you post what code you are trying to use (after concatenating)?

 

[omaggi]

I use the code you posted...but I have an error about type of data...

 

[boblarson]

I use the code you posted...but I have an error about type of data...

So what is the actual data type (in the table) of:

[id_name]

And

[id_address]

 

[omaggi]

The 2 field are "numeric"...

 

[boblarson]

The 2 field are "varchar"...

So these are from a linked SQL Server table?

 

[boblarson]

Oh, and are these controls TEXT boxes or COMBO boxes?

Me.ccName
Me.ccAddress

 

[omaggi]

I use combo box...

 

[boblarson]

Ah, so go ahead and see if this works without the Chr(34).

DMax("age", "data", "[id_name] = " & Me.ccName & " And [id_address] = " & Me.ccAddress)

 

[omaggi]

Thanks now it works!!!

Thank you so much.

Greetings.

 

[boblarson]

Cool, glad it works for you.