Hello, I'm using Access 2000 to connect to QuickBooks Pro 2006 (Canadian Version)

When I run the following SQL statement in Microsoft Access, I can add records with no problem but I have a couple of fields that don't seem to be inserting properly.

 DoCmd.RunSQL "INSERT INTO ItemInventory (Name, IsActive, SalesDesc, IncomeAccountRefListID, PurchaseDesc, PurchaseCost, " & _
                "COGSAccountRefListID, AssetAccountRefListID, InventoryDate, TotalValue, QuantityOnHand) " & _
                "VALUES ('JustTesing', TRUE, 'JustTestingSalesDesc', '350000-1078292072', 'JustTestingPurchaseDesc', 3500, '3E0000-1078292072', " & _
                "'C0000-1078292071', #2006-05-02#, 3500, 1)"

1) The above statement ends up putting the TotalValue figure against the AverageCost in Quickbooks. Am I missing something here ???

2) I'm having problems actually inserting into the InventoryDate field. I must not be using the correct syntax . Does anyone know the correct syntax ??

See: How do I add a Inventory Item using QODBC? 

MS Access uses your system date format so I'm guessing it's MM-DD-YYYY so it should be #05-02-2006# ? Because the quantity is 1, the purchase cost will become the Average Cost in QuickBooks.