How to take out the values ​​in one table by year and month and add them to calculate in another table ???

blackmoon

One table stores data, and the other table calculates the records of the first table and displays them

The calculation should be automatically calculated on a year-by-month basis, I will not engage in it, I hope everyone will give pointers!

blackmoon

When the data in the first table is stored, each record is dated when it is stored

xiaofeigou

Is it a group?
You can use the GROUP BY clause.

lancelot0229

Write down the two table structures, and then write out your requirements, I will write for you

kriesscoen

I don't know if it's right, my understanding is limited, and I will answer according to my own understanding.

If the first table is data, the second table recommends that you do not make a table, it is more appropriate to make a View.

If the first table uses year and month as the standard for grouping, you can use six bytes of character data to represent the year and month, such as:

YearMonth C (6) // '200602' or directly use date data {^ 2007-02-01}, the following can be created

A View

  Create View second table As;
    Select YearMonth, Count (YearMonth) As Counts, Sum (Total) As Totals;
    From the first table Group By YearMonth

Then open this view at any time, and you can dynamically get the relevant data in the first table at any time.

170385215

Write down the two table structures, and then write your requirements and results