Display Data

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

Guest

Hi

I have a table where I upload sales for the day, I have a few people who
will upload data and to avoid reproducing results I would like a box next to
my upload button to display the date of the last upload. I have created a
groups totals query displaying the max date. How can I show that in a text
box in my switchboard please.

Many thanks

Kerry.
 
To show the max date in the textbox, make it a calculated textbox using the
DMax() function.

Example Control Source:
=DMax("[DateField]", "[TableName]")
 
Back
Top