Table Completion Time

G

Guest

I have a series of do.cmd's that run queries that are executed when I click a
command button from a form. All of these queries make or append to tables.

What I want is a way to have a summary table that specifies all table names
that just got made or appended to, the date/time when each table was last
made or appended to, and how many records are on each table.

I'm not sure how to do this or if I need to do this in code or using an
update query.

Can someone point me in the right direction?
 
S

Steve

It sounds like what you are trying to do is flawed. Why don't you post what
you are trying to accomplish with all the make table and append queries.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending null data and moving! 4
Append to two different tables 23
Queries losing fieldnames when importing from external mdb 2
Append Query 1
update and append queries 1
Max & Min Dates 0
How to Populate Data from a table to another 0
Append Query isn't working 2

Top