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
Seamus2626Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.