Ok well basically i have a field in my database with a forward slash in the middle of the field name. The first Sql statement works perfectly where i've omitted the field. And the second one where i put it in.. does not work.

If anyone has any ideas or suggestions i'd appreciate it greatly. I've been working on this program for about two months and something so rediculous as an sql statement error is killing me. Thanks Again

Set rstTemp = conMAS90.OpenRecordset("
SELECT ARN_InvHistoryHeader.CustomerNumber,
ARN_InvHistoryHeader.InvoiceNumber,
ARN_InvHistoryHeader.SOOrderDate,
ARN_InvHistoryHeader.SOShipDate,
ARN_InvHistoryHeader.SOSourceJournal,
ARO_InvHistoryDetail.SOItemNumber,
ARO_InvHistoryDetail.SOHasPriceBeenOverridden,
ARO_InvHistoryDetail.SOQtyShipped,
ARO_InvHistoryDetail.SOUnitPrice
FROM ARN_InvHistoryHeader, ARO_InvHistoryDetail
", dbOpenDynamic)


Set rstTemp = conMAS90.OpenRecordset("SELECT ARN_InvHistoryHeader.CustomerNumber, ARN_InvHistoryHeader.InvoiceNumber, ARN_InvHistoryHeader.SOOrderDate, ARN_InvHistoryHeader.SOShipDate, ARN_InvHistoryHeader.SOSourceJournal, ARO_InvHistoryDetail.SOItemNumber, ARO_InvHistoryDetail.SOHasPriceBeenOverridden, ARO_InvHistoryDetail.SOQtyShipped, ARO_InvHistoryDetail.SOUnitPrice, ARO_InvHistoryDetail.Extd/ChargeAmount FROM ARN_InvHistoryHeader, ARO_InvHistoryDetail ", dbOpenDynamic)

~Jay