add column to calculate difference between columns in a crosstab query

[Access_Help]

I have 10 columns in a cross tab query each representing a month jan to oct.

I want to add a column to calculate the difference between the numbers in two adjacent columns

For example the difference between jan and feb results
Feb and march
March and april etc

 

[CJ_London]

think you will either need to use a second query based on the first (probably the easiest) or have a second crosstab to calculate the difference and then combine with the first crosstab

 

[Access_Help]

Thanks CJ. Do you have an example I can work from?