I would like to add this expression:
(/-1) AS [Change%]
As a field to the crosstab query below:
(((Data.Year)="2012" Or (Data.Year)="2013"))
For my purposes I need to have everything together in one query.
This is because I am writing SQL in another program, PTReportGen,
which uses the query to directly access an Access database.
Please don't mind of me, this forum is for Data mining and not for either TSQL or Access/SQL. Please move this to relevant forums for better answers.
As Prav said, to get dedicated support for the query statements of Microsoft Access 2010, please ask a question in the following forum:
I am not familiar with the Reporting tool of PTReportGen. In SQL Server Reporting Services, this requirement can be done easily achieved via expressions in the report.
TechNet Community Support
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?