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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate MTD and YTD in a query 8
SubQueries in Column 1
Another MTD/YTD Running Totals Question 2
mtd and ytd formula issues 4
Current Date, MTD, YTD, Last Year's MTD 3
Update query 2
YTD Subquery problems 3
SQL Query Problem 6

Back
Top