MAX DATE IN QUERY

[sal21]

SQL = "Select * From TAB WHERE AGG=#15/09/2010#"

Instead the fixed date is possible to filterd the max date into the filed AGG and store the value of max date in a variable?

[HansV]

You could use

SQL = SELECT Max(AGG) As MaxAGG FROM TAB"

Open a recordset on this SQL string, let's say you name it RS. Then use

MyVar = RS!MaxAGG

to store the value in a variable.

[sal21]

You could use

SQL = SELECT Max(AGG) As MaxAGG FROM TAB"

Open a recordset on this SQL string, let's say you name it RS. Then use

MyVar = RS!MaxAGG

to store the value in a variable.

But your query select also all records whit the filter MaxAGG?
i have used * param in my old query...

[HansV]

Sorry, I don't understand. Do you want to select the entire record or do you want to get the maximum value of AGG?

[sal21]

Sorry, I don't understand. Do you want to select the entire record or do you want to get the maximum value of AGG?

I need to extract all records from tab where the max date are preesnt in AGG

[HansV]

OK, try this then:

SQL = "SELECT * FROM TAB WHERE AGG=(SELECT Max(AGG) FROM TAB)"

[sal21]

OK, try this then:

SQL = "SELECT * FROM TAB WHERE AGG=(SELECT Max(AGG) FROM TAB)"

I lo** you!