smudger70uk
New member
- Local time
- Today, 07:50
- Joined
- May 5, 2011
- Messages
- 7
Hi,
I have a number of tables that hold datasets that are created either daily or weekly to provide data for employees to perform equipment checks and record the status of these. These datasets are created individually via a central form (form button for each runs append queries to create the latest dataset and date stamps the records)
What I'm struggling with is a way to display to the user the last date the dataset was created. I'd hoped I could simply add a number of text fields to the form and use the control source to create an expression to display the max date of the records in the tables as below:
=Max([tblOCIC_EPIC_Check_Records]![Check_Date])
Unfortunately the text box display #Error. I'm guessing this is quite a basic requirement but my Access is so rusty I can't figure it out myself so any help is very welcome.
Thanks in anticipation.
I have a number of tables that hold datasets that are created either daily or weekly to provide data for employees to perform equipment checks and record the status of these. These datasets are created individually via a central form (form button for each runs append queries to create the latest dataset and date stamps the records)
What I'm struggling with is a way to display to the user the last date the dataset was created. I'd hoped I could simply add a number of text fields to the form and use the control source to create an expression to display the max date of the records in the tables as below:
=Max([tblOCIC_EPIC_Check_Records]![Check_Date])
Unfortunately the text box display #Error. I'm guessing this is quite a basic requirement but my Access is so rusty I can't figure it out myself so any help is very welcome.
Thanks in anticipation.
