DoCmd. RunSQL "TRANSFORM the Sum ([excluding tax]/1000) AS expression 1" _
& "SELECT code. Its operation business address" _
& "FROM dbo_ sales - all INNER JOIN (dbo_ customer card INNER JOIN business address code ON card dbo_ customers. Business=business address code. The code) ON dbo_ sales - all. Customer=dbo_ card. Customer code" _
& "WHERE ((dbo_ sales - all. Processing date) Between # 3/1/2017 # And # # 3/31/2017)" _
& "GROUP BY business address code. Business address" _
& "The PIVOT Day (sales - all] [dbo_ month! [date]);"
Why not run in the form, the transform pivot grammar have a problem, please instruct how to change
CodePudding user response:
Transform the pivot is crosstab query, cannot use DoCmd. RunSQL. DoCmd. RunSQL can perform don't need to return the result of the query, such as: additional query, update queries, generate table query, delete query and so on