query criteria on max value of another query

[diegomarino]

Hi, i have this query (lk contatti nuovi) that has a parameter in which i put a date


i made another query (lk max connesso il) in which i get the max value of a field as you can see





in the first image on the "lk contatti nuovi" query i added the second query, i'd like to get rid of the parameter and use as criteria the value of "lk max connesso il"

is there anby way?
thanks

[CJ_London]

just change to >[MaxDiconnesso il]

note spaces in field names is not a good idea. Also your second query appear to generate a different field name to the one showing in the first query (don't know if it is a language issue but Max is showing as MaxDi)

[diegomarino]

thanks, i had to make another query cause there were some problem for aggregation but with the new query it worked

"Maxdi" means "MaxOf" so it's ok

[CJ_London]

I'm surprised your query actually worked as you are combining a outer join with a cartesian (no join). Perhaps your new query resolves that.

[diegomarino]

i'll never give you my secrets