When doing the monthly summary to the inside of the extracted in February, according to their assignment dates as long as a name, the name is the man behind the working hours in this month's income, need to use the database of the cross? How to implement?

CodePudding user response:

This is the screenshot, interpretation, thank you!

CodePudding user response:

SELECT workers, the MONTH (homework time) AS in SUM (the hours) AS monthly working hours
FROM the table name
GROUP BY operation personnel, the MONTH (homework)

CodePudding user response:

A: standard data type does not match the expression;
Is your SUM (the hours) AS monthly working hours is this SUM? Now I just need to show separately,

CodePudding user response:

Crosstab query, you might as well use Access query wizard, choose one of the crosstab query wizard, can automatically generate the query code,

CodePudding user response:

Time Format (homework, "yyyy - mm)"