Creating a Macro to run multiple Queries - Help

[lwilt]

When making a new macro to run a list of queries, let's say 5 queries for example, I pick the action to be OpenQuery but I can't seem to figure out what I need to pick for the drop downs for View and Data mode so that the Query will just run to the make table I have in design mode.

Is choosing OpenQuery correct? If not what action should I use? And what do I pick for the drop downs?

 

[Joe4]

INSERT INTO [RFM Test Table] ( [RFM Code], Cust_NO, [Last Order], [Avg Order], [Number of Orders], [First Contact Method] )
SELECT "A1B" AS [RFM Code], [RFM Customers and Orders].Cust_NO, Last([RFM Customers and Orders].[Order Date]) AS [Last Order], Avg([RFM Customers and Orders].Sales) AS [Avg Order], Count([RFM Customers and Orders].[Order Number]) AS [Number of Orders], First([RFM Customers and Orders].[First touch]) AS [First Contact Method]
FROM [RFM Customers and Orders], [GlobalSettings]
GROUP BY "A1B", [RFM Customers and Orders].Cust_NO
HAVING (((Last([RFM Customers and Orders].[Order Date]))>=[GlobalSettings].[StartDate] And (Last([RFM Customers and Orders].[Order Date]))<[GlobalSettings].[EndDate]) AND ((Avg([RFM Customers and Orders].Sales))<220) AND ((Count([RFM Customers and Orders].[Order Number]))>=16) AND ((First([RFM Customers and Orders].[First touch]))<>"Internet" And (First([RFM Customers and Orders].[First touch]))<>"WEB"));

 

[lwilt]

thank you sir....I will be testing this out after xmas and hopefully works for me