Linking through ODBC to Access Quickbooks - View in Pivot Table

J

Jo Grace

I have link Quickbooks to Access 2002. I have joined a couple of tables and
created a query.

This query looks at InvoiceLineAmount i.e $79.95 - in the datasheet if
reflects exactly what I want.

However when I go to PivotTable View - It only returns $79.00. I am at a
lost! I have looked and looked the formats etc and for the life of me - I
CANNOT SEE

Does anyone have any answers ----- Please!
 
Top