Use specific value in the last record in a query

[Sylvialn]

I am trying to use a value located in the last record of a query. I need to know how to access the value through the code builder. I would like to go to the query, locate the last record in the query, and use a specific value located in one of the fields in the query. I have tried the .MoveLast method,b ut cannot get it to work, or anything else.

 

[Psychpt]

create a recordset from the query
then movelast
then get the field value you want from that record.

If you want the correct syntax for all that the give us the names of all the objects you're working with.

HTH
PsychPt@hotmail.com