Dlookup for First Record In Table

G

Guest

tblAccountInfo table has a date field (Updated) that is set with a date
default of the day that data is imported. The same date appears for all the
records in the table. I want my main form to show the last time data was
imported into the tblAccountInfo table. I currently have a subform with the
import date in it. Can I use Dlookup instead? The only fields in common is
"Updated"

frmMainForm tblAccountInfo field: Updated
 
M

Marshall Barton

SharonInGeorgia said:
tblAccountInfo table has a date field (Updated) that is set with a date
default of the day that data is imported. The same date appears for all the
records in the table. I want my main form to show the last time data was
imported into the tblAccountInfo table. I currently have a subform with the
import date in it. Can I use Dlookup instead? The only fields in common is
"Updated"

frmMainForm tblAccountInfo field: Updated


If the value of the date field is the same in all the
records, it doesn't matter which record you get the value
from, so, yes, DLookup will do that.

Use a text box with the control source expression:
=DLookup("Updated", "tblAccountInfo")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top