• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

Query a crosstab query

Hi,

I have a cross tab query that returns me sales peoples sales on YTD basis.

So i have sales x, sales April, Sales May

Unfortunately as the data is YTD, the only way we can view month by month basis is to subtract May from April, and the uplift in sales is Mays figures

So can i create a query that looks at columns May and April and returns all sales people with the uplift data i.e May minus April

In the attached spreadsheet i added a column to show the expected result

Many thanks
Test.xlsx
0
Seamus2626
Asked:
Seamus2626
  • 2
  • 2
1 Solution
 
Randy PooleCommented:
Also post the SQL for your cross tab returning YTD
0
 
Seamus2626Author Commented:
The YTD data is bought in via excel, into a linked table. So im thinking calc fields?

i.e May - Apr = May Actual
0
 
Randy PooleCommented:
You have a linked table, but you have to have a SQL query to run against that table.  I need to know the syntax of this query.
0
 
Seamus2626Author Commented:
So, i run a simple append query to create static tables, the append query builds up month on month data

Now i am trying to seperate that data into a month by month view, i cant just flag it by date as the data is received YTD, so i must subtract this months YTD from last months YTD
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now