Datestamp status change query

[naomi]

I got a database which has several different tables which I want to update to a new table which will automatically update everytier somebody eters information.
But here's the problems:
1. I am trying to get a status on each client per representative. They enter several statuses during the day, but I only want my table to update the very last status of the day. i know i can do this by putting a max date on the stamp, but can i just have a table that will enter this new data i without having to write a macro to update the table daily?
2. The main reason I don't want to use just the status table is because my data for the report I need is on 4 other tables, so ideally I want a regular table that I don't hAVE TO UPDATE EVERY DAY. I JUST WANT TO Take columns from 5 different tables into one table and run queries off that.
5. I don't know how to do any of the above without having to use and update query.

Please help me!! as many responses as possible would be appreciated!@!!

 

[dcx693]

1. You can use a totals query to pick the last status entered for each client. No macros required.

2. Whether or not you can easily grab columns from 5 different tables and show them in one query depends on the tables. Can you post some more info about the structures of the tables? If they're all the same structure, that's great, but to show it all in one query they either need to be related somehow or you'll have to combine that data.

Don't be scared off though, the above processes aren't that difficult and maybe someone can post some better ideas.

 

[naomi]

yes they are all related by clientnumber. but how do i make the process automatic?? I know how to do it, i just dont know how to make it automatic. general answers would be appreciated as well!!

 

[Chasedog]

Ideally, you'd just run the query on the five tables instead of one. Unless there's some design issue, you shouldn't even bother trying to repeat data from one table in another. Once you've created the query, you can base other queries, forms, and reports off the new query. That way, it's automatic.