Results 1 to 3 of 3
  1. #1
    TerraEarth is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    86

    Creating a auto-updating table based off another Table?

    Let's say that I have a customer's table (SalesByCustomer) with a list of purchases that the customer had bought.
    Let's say that I only want to work with aggregate sales for each customer, but I still want to preserve the individual purchase lists for reference purposes.

    How then would I create a new table, AggregateSalesByCustomer that does the following:

    1) Group Customers together and sum up their purchases and link it to their customer ID


    2) Populate a new table with the aggregate/ID fields
    3) Carry-over fields from the original SalesByCustomer table such as their contact number, email, etc.
    4) Automatically update the new table (AggregateSalesByCustomer) depending on new data flowing into the base table - SalesByCustomer?

    Is this possible? Is there a simpler way to do this? How would I go about implementing such a feature?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  3. #3
    TerraEarth is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    86
    Upon further thought I came to the conclusion that queries were probably the way to go (probably). Wanted to get an idea of what kind of options there were and so on so forth.

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

Similar Threads

  1. Replies: 1
    Last Post: 02-23-2016, 05:00 PM
  2. Replies: 1
    Last Post: 11-04-2014, 12:07 PM
  3. Replies: 6
    Last Post: 08-20-2014, 04:45 PM
  4. Replies: 6
    Last Post: 05-10-2012, 08:20 PM
  5. Replies: 0
    Last Post: 03-27-2011, 02:05 PM

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