Exporting crosstab query to excel

  • Thread starter Thread starter Ted N.
  • Start date Start date
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!!
 
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
 
Back
Top