Exporting crosstab query to excel

T

Ted N.

A user here at work has informed me when she exports a
crosstab query to excel some of the data from some of the
columns in the crosstab query shifts into incorrect
columns in the excel spreadsheet. HELP!!
 
D

Duane Hookom

You would need to provide some value for all of the "cells". It would sure
help if you had pasted the SQL....
However you could create a Value expression like:
TheValue: Val(Sum(Nz([Qty],0)))
Totals: Expression
 

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

Top