This is MS Query playing up, I just did:
SELECT SalesLine.TxnID, SalesLine.TimeCreated, SalesLine.TimeModified, SalesLine.EditSequence, SalesLine.TxnNumber, SalesLine.CustomerRefListID, SalesLine.CustomerRefFullName, SalesLine.ClassRefListID, SalesLine.ClassRefFullName, SalesLine.ARAccountRefListID, SalesLine.ARAccountRefFullName, SalesLine.TxnDate, SalesLine.TxnDateMacro, SalesLine.RefNumber, SalesLine.BillAddressAddr1, SalesLine.BillAddressAddr2, SalesLine.BillAddressAddr3, SalesLine.BillAddressAddr4, SalesLine.BillAddressAddr5, SalesLine.BillAddressCity, SalesLine.BillAddressState, SalesLine.BillAddressPostalCode, SalesLine.BillAddressCountry, SalesLine.BillAddressNote, SalesLine.ShipAddressAddr1, SalesLine.ShipAddressAddr2, SalesLine.ShipAddressAddr3, SalesLine.ShipAddressAddr4, SalesLine.ShipAddressAddr5, SalesLine.ShipAddressCity, SalesLine.ShipAddressState, SalesLine.ShipAddressPostalCode, SalesLine.ShipAddressCountry, SalesLine.ShipAddressNote, SalesLine.IsPending, SalesLine.CheckNumber, SalesLine.PaymentMethodRefListID, SalesLine.PaymentMethodRefFullName, SalesLine.IsFinanceCharge, SalesLine.PONumber, SalesLine.TermsRefListID, SalesLine.TermsRefFullName, SalesLine.DueDate, SalesLine.SalesRepRefListID, SalesLine.SalesRepRefFullName, SalesLine.FOB, SalesLine.ShipDate, SalesLine.ShipMethodRefListID, SalesLine.ShipMethodRefFullName, SalesLine.Subtotal, SalesLine.ItemSalesTaxRefListID, SalesLine.ItemSalesTaxRefFullName, SalesLine.SalesTaxPercentage, SalesLine.SalesTaxTotal, SalesLine.Amount, SalesLine.Remaining, SalesLine.Memo, SalesLine.IsPaid, SalesLine.CustomerMsgRefListID, SalesLine.CustomerMsgRefFullName, SalesLine.IsToBePrinted, SalesLine.IsToBeEmailed, SalesLine.CustomerSalesTaxCodeRefListID, SalesLine.CustomerSalesTaxCodeRefFullName, SalesLine.SuggestedDiscountAmount, SalesLine.SuggestedDiscountDate, SalesLine.DepositToAccountRefListID, SalesLine.DepositToAccountRefFullName, SalesLine.CreditMemoLineGroupIsPrintItemsInGroup, SalesLine.Type, SalesLine.SalesLineType, SalesLine.SalesLineSeqNo, SalesLine.SalesLineGroupTxnLineID, SalesLine.SalesLineGroupItemGroupRefListID, SalesLine.SalesLineGroupItemGroupRefFullName, SalesLine.SalesLineGroupDesc, SalesLine.SalesLineGroupQuantity, SalesLine.SalesLineGroupIsPrintItemsInGroup, SalesLine.SalesLineGroupTotalAmount, SalesLine.SalesLineGroupSeqNo, SalesLine.SalesLineTxnLineID, SalesLine.SalesLineItemRefListID, SalesLine.SalesLineItemRefFullName, SalesLine.SalesLineDesc, SalesLine.SalesLineQuantity, SalesLine.SalesLineRate, SalesLine.SalesLineRatePercent, SalesLine.SalesLineClassRefListID, SalesLine.SalesLineClassRefFullName, SalesLine.SalesLineAmount, SalesLine.SalesLineServiceDate, SalesLine.SalesLineSalesTaxCodeRefListID, SalesLine.SalesLineSalesTaxCodeRefFullName, SalesLine.FQPrimaryKey, SalesLine.FQTxnLinkKey, SalesLine.CustomFieldBDay, SalesLine.CustomFieldContract, SalesLine.CustomFieldSpousesName, Item.ListID, Item.TimeCreated, Item.TimeModified, Item.EditSequence, Item.Name, Item.FullName, Item.Description, Item.IsActive, Item.ParentRefListID, Item.ParentRefFullName, Item.Sublevel, Item.Type, Item.SalesTaxCodeRefListID, Item.SalesTaxCodeRefFullName, Item.SalesOrPurchaseDesc, Item.SalesOrPurchasePrice, Item.SalesOrPurchasePricePercent, Item.SalesOrPurchaseAccountRefListID, Item.SalesOrPurchaseAccountRefFullName, Item.SalesAndPurchaseSalesDesc, Item.SalesAndPurchaseSalesPrice, Item.SalesAndPurchaseIncomeAccountRefListID, Item.SalesAndPurchaseIncomeAccountRefFullName, Item.SalesAndPurchasePurchaseDesc, Item.SalesAndPurchasePurchaseCost, Item.SalesAndPurchaseExpenseAccountRefListID, Item.SalesAndPurchaseExpenseAccountRefFullName, Item.SalesAndPurchasePrefVendorRefListID, Item.SalesAndPurchasePrefVendorRefFullName, Item.SalesDesc, Item.SalesPrice, Item.IncomeAccountRefListID, Item.IncomeAccountRefFullName, Item.PurchaseDesc, Item.PurchaseCost, Item.COGSAccountRefListID, Item.COGSAccountRefFullName, Item.PrefVendorRefListID, Item.PrefVendorRefFullName, Item.AssetAccountRefListID, Item.AssetAccountRefFullName, Item.ReorderBuildPoint, Item.InventoryDate, Item.DepositToAccountRefListID, Item.DepositToAccountRefFullName, Item.PaymentMethodRefListID, Item.PaymentMethodRefFullName, Item.TaxRate, Item.TaxVendorRefListID, Item.TaxVendorRefFullName, Item.CustomFieldColor, Item.CustomFieldMaterial, SalesLine.TxnDate FROM Item Item, SalesLine SalesLine WHERE SalesLine.SalesLineItemRefListID = Item.ListID AND ((SalesLine.TxnDate>={d '2006-01-01'} And SalesLine.TxnDate<={d '2008-01-01'}))
Try building the query manually. |