SQL result from table to textbox - simple but need help.

[dssjon]

Hello there,

I'm using

 =DLookUp("[Username]&'on '&[Date]","Lastrun")

as the parameter for control source in a textbox to display a username and date on a form. The username and date is located in a log table named lastrun. Dlookup is returning the first record from the table but what I need is the newest value in the table, which is the last record of the table. Can anyone out there give me some advice? Thanks!

 

[PHV]

Perhaps this ?
=DLast("[Username]& ' on '& [Date]", "Lastrun")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[peebatron10k]

Specify the following query and save it:

SELECT Lastrun.Username, LastRun.Date FROM Lastrun ORDER BY LastRun.Date Desc;

then use DFirst on this query instead of the table:

=DFirst("[Username] & ' on ' & [Date]","NewQuery")

perhaps, alternatively use DAO