How can I subtract values in a crosstab query?

G

Guest

I'd like to subtract two GWElevation values in an Access 2003 crosstab query
that displays values for two quarters to see the change in GW elevation btw
subsequent quarters. How can I subtract these values in my crosstab query? I
am not familiar with hardly any VBA code, so if that is what it takes, please
be detailed about how I would go about doing this.

If anyone could help, I'd sure appreciate it.

Kim
Tucson, AZ
 
G

Guest

You will not need VBA. See my other post.
The crosstab wizard builds columns for the row label, Totals, and your
column divisions. Sounds to me like all you have to do is to modify the
expression for the Totals output.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting values in a crosstab query 1
How can you compress / group by on a crosstab query when column names are unknown 2
Crosstab Query based on Query 4
Crosstab - Multiple values on each row 5
Include empty values in crosstab query 5
Multiple column values in crosstab query 2
Varying Number of Columns in Crosstab Query 2
Parameter in a crosstab query 4

Top