Use the last value in a select query in a control on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I'm trying to set the value of a control on a form to the last value of a
select query.

The query is as follows :
SELECT TOP 1 tblTrans.intLOdo
FROM tblTrans
WHERE (((tblTrans.strRegNo)="dzr365n") AND
((tblTrans.strTypeTrans)="BRANDSTOF"))
ORDER BY tblTrans.dtmDate DESC;

But I can't seem to set the control's value to tblTrans.intLOdo.

Help much appreciated
 
Back
Top