Results 1 to 2 of 2
  1. #1
    symphony is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2011
    Posts
    1

    Add Event To Automatically Run Make Table Query

    I need it to do add an event to my database so that when a record is addded to table A, it automatically runs query B (Make table query) to update my totals in table C.



    I currently use this database an ASP driven website.

    Thanks,

    Anthony

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Quote Originally Posted by symphony View Post
    I need it to do add an event to my database so that when a record is addded to table A, it automatically runs query B (Make table query) to update my totals in table C.
    I'm getting a bit confused.

    You want to run B a MAKE TABLE query to UPDATE table C?

    A make table query doesn't update anything, it creates a new table

    So are you trying to MAKE a temporary table of some sort or are you trying to run an UPDATE QUERY?

    Also, why do you want to maintain a summary table when you could create a query that does any sort of summarizing you want? You could then reference the summary query. This would prevent you from having to store and update data permanently (leaving yourself open to errors).

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-30-2010, 10:28 AM
  2. make-table query
    By 3PS in forum Access
    Replies: 2
    Last Post: 06-28-2010, 12:54 PM
  3. Run Make Table query automatically
    By tuna in forum Queries
    Replies: 5
    Last Post: 05-10-2010, 03:15 AM
  4. Make table query
    By Zahed in forum Queries
    Replies: 1
    Last Post: 11-06-2009, 05:44 AM
  5. Replies: 2
    Last Post: 10-27-2009, 07:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums