This should be simple....

[Opal]

....but I can't find the answer anywhere....

I have an unbound form in Access 2003. Its
a simple database that I import data from Excel into
to run a query. All I want to be able to do, is, in
a text box on the form show the last value in the
date column of my table that contains the values I
have imported. I want to be able to see the last
date value imported so I do not overlap
dates. Can anyone help me?

 

[Albert D. Kallal]

Do you mean the max date????

You can put a text box on a form (lets call it my last date).

=dmax("Date field","Table Name")


If your last row might not be the "max" date, then the above answer might
not be what you are looking for....

 

[Opal]

Do you mean the max date????

You can put a text box on a form (lets call it my last date).

=dmax("Date field","Table Name")

If your last row might not be the "max" date, then the above answer might
not be what you are looking for....

Thank you, Albert, that is exactly what I was looking for!