Update/Append Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I ran a query that creates a table for YTD Info. I added fields for mtd info. I then have a query that gathers mtd values. I want to update my YTD table with this info for each customer. How can I do this.
 
I ran a query that creates a table for YTD Info. I added fields for mtd info. I then have a query that gathers mtd values. I want to update my YTD table with this info for each customer. How can I do this.
Click to expand...

Normally one would not store MTD *or* YTD information in a table AT
ALL; instead you would just store the actual transactions, and run
separate Totals queries to sum the transactions since the first of the
year or the first of the month. Could you explain why you want to
store the data in a Table, knowing that the next time a customer makes
a purchase, that table will be out of date?
 
Back
Top