469,578 Members | 1,322 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,578 developers. It's quick & easy.

consolidating tables

16
hi, I am using Access 2003.
I have many tables which track the changes made to the data base. Each table caters to one previously existing table. Hope my explanation is clear enough. Each table have the same fields as previously existing table with addition of username (who makes the change) and date (when the change is made). Basically the old data and new data are both appended to the new tables.I want to consolidate all the tables into one so that someone can just focus on one particular date or time and see all the changes made to the database, and probably in the report as well. I want to know how to possibly write this query so that the primary key will be date as all the changes are recorded and sorted by their dates. Thank you for anyone who would look at my problem.

xiaowei
Jun 26 '07 #1
0 1010

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by David | last post: by
44 posts views Thread by Mariusz Jedrzejewski | last post: by
6 posts views Thread by imani_technology_spam | last post: by
3 posts views Thread by Random Person | last post: by
11 posts views Thread by dskillingstad | last post: by
2 posts views Thread by Gregc. | last post: by
59 posts views Thread by phil-news-nospam | last post: by
1 post views Thread by Monkey Boy | last post: by
5 posts views Thread by rdemyan via AccessMonster.com | last post: by
2 posts views Thread by yasmine | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.