Can A2007 do this

[gemma-the-husky]

If you have a totals query to find the highest value in a table (say) - you often need to get some other info about that highest value record (say the date)

but there's apparaently no way of getting that extra field in to the base query, as an expression or anything else - because then it treats the new field as a group by, so you no longer get the max value

is there any way of doing this directly, other than doing a dlookup for the max value you just retrieved.

 

[boblarson]

If you have a totals query to find the highest value in a table (say) - you often need to get some other info about that highest value record (say the date)

but there's apparaently no way of getting that extra field in to the base query, as an expression or anything else - because then it treats the new field as a group by, so you no longer get the max value

is there any way of doing this directly, other than doing a dlookup for the max value you just retrieved.

Just like any other version -

Use a subquery. Use the first query to get the max date for whatever you have and then in ANOTHER query use that first query linked to the date fields (and any other shared fields) and you should be on target.