Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update info table with info in 4 different queries evry month

Status
Not open for further replies.

simma

Programmer
Sep 11, 2001
398
US
Hello
I have 4 queries which give info on 4 diffenet criteria.I have to update a table evrymonth with that months information from these four queries.Im out of ideas.Can anyone please guide me?
Thanks
 
what do you want help with, scheduling the queries to run or is the queries themselves?

Please give more info and i will try to help?
 
Thanks wonderhands!Anything will do!Even basic idea how I can approach this problem.
Thanx
 
Suggest start with learning about update and make table queries. (See Access Help or a good Access reference.) With these queries, you create the query with the updated info and then run the query to create a new table or to overwrite an existing table with the new info. Hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top