I've recently created a database for a few users here. My only issue is in order to make it easy for all involved i had to give everyone access to update the database. My concern with this is i have the data going to a make table from an append query. I do not have a delete query since the data can only be pulled daily from a nightly back up on our as400 and the users want to be able to see past data. If i run a delete query that data would be gone.
I want to create a label/button on the switchboard that will show when the last time my database was updated. I tried to create a query using my make tables data filtering date with the max function but when i create a label and use that query as my control source i get Name? as a result.
Does anyone know an easier way to do this?
Edit: Either googlez failed me or i failed at the googlez ;/
I want to create a label/button on the switchboard that will show when the last time my database was updated. I tried to create a query using my make tables data filtering date with the max function but when i create a label and use that query as my control source i get Name? as a result.
Does anyone know an easier way to do this?
Edit: Either googlez failed me or i failed at the googlez ;/