Action Queries

[amolbehl]

Hi,

I have a query

INSERT INTO GroupedOrderDetail_Bulk ( CustomerNo, OrderDate, RouteNo, SumOfQty, item )
SELECT OrderDetail.CustomerNo, OrderDetail.OrderDate, OrderDetail.RouteNo, sum(OrderDetail.Qty) AS SumOfQty, OrderDetail.item
FROM OrderDetail
WHERE (((OrderDetail.DeliveryMethod)=3))
GROUP BY OrderDetail.OrderDate, OrderDetail.RouteNo, OrderDetail.CustomerNo, Orderdetail.item
ORDER BY OrderDetail.OrderDate;


Now this query inserts records into a table. I need to run this query thru a VB6 script. Can anyone tell me how.

I did not know where to put this question (Access or VB forms) .

Thanx in advance

[Scott Price]

If this is VBA, the answer is:

Dim MySQL as String
 
MySQL = "[YourInsertIntoStatement]"
 
DoCmd.RunSQL MySQL

However, VB6 is a different animal, with which I am not too familiar. If this is in fact, VB6, let me know and I'll move it over to the VB forum.

Regards,
Scott