Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Cost Code Report from Pastel
Sorry do not have an SQL code or just don't know what you mean by that. I'm just a user trying to build a cost code report via a database query and then into a Pivot. The source data that I access comes from Pastel. The table I use were the History Headers and the Ledger Transactions with the... -
-
Cost Code Report from Pastel
Using System DSN Pervasive ODBC Engine Interface -
Cost Code Report from Pastel
Hi, I'm trying to pull a cost code report from Pastel into Excel via a data base query. The table "History Headers" with "Ledger Transactions" used to work. However as soon as an invoice has various items with different cost codes, it does not label the document with a cost code at all. I tried...
