Hello,
I've looked and saw variations of this problem but not exactly what I need:
Users will be using a form to import text files into tables in the database. Reports will be run from these different files through queries. I want to be able to list the tables and list the date/time that they were updated next to them. This way, if they have for instance the "items" table that was brought in today but the "usage" table is a couple days old, I want them to be able to see that at a glance.
What I want is to have a text box next to each table name showing when it was last imported. FYI - the tables will be cleared through a delete query then imported with an import spec into the table.
I've looked and saw variations of this problem but not exactly what I need:
Users will be using a form to import text files into tables in the database. Reports will be run from these different files through queries. I want to be able to list the tables and list the date/time that they were updated next to them. This way, if they have for instance the "items" table that was brought in today but the "usage" table is a couple days old, I want them to be able to see that at a glance.
What I want is to have a text box next to each table name showing when it was last imported. FYI - the tables will be cleared through a delete query then imported with an import spec into the table.
