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
 

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

Export crosstab query to Excel: Row hight and Decimal 6
Query a crosstab query 2
Make-table query with around 2 ml records taking too long 0
export crosstab query too many fields defined 4
How to update data in a query 1
crosstab query? 3
Crosstab column data count 6
Crosstab query - I need aditional information 1

Back
Top