MS ACCESS - How to create a Query with SQL Command?

Question

I know how to create a Query though Query Design (manually)

but how to create a "Query" with command? i am looking for something like

Create Query [Query_Name] 
As
Select * from Table1

Can anyone post me the code snippet that can do something like this?

Things i have TRIED

Erik von Asmuth's solution : The below query

CREATE PROCEDURE MyQuery [@Param1] Integer; SELECT * FROM SalesInvoice WHERE SalesInvoice.S_Id = [@Param1]

gave the following error

Erik A · Accepted Answer · 2017-10-26 09:47:18Z

1

You can use the PROCEDURE command. Since Access doesn't have stored procedures, that just creates a query.

E.g.:

PROCEDURE MyQuery
[@Param1] Integer;
SELECT *
FROM MyTable
WHERE MyTable.ID = [@Param1]

The use case is pretty limited, since queries are usually created through VBA using the CurrentDb.CreateQueryDef method.

answered Oct 26, 2017 at 9:32

Erik A

32.8k13 gold badges48 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

i have tried it and it didnt work, for more detail see the updated question

You haven't executed it through ADO, which is necessary for it to work

can you please explain how to do that?

Search VBA help for CREATE PROCEDURE, it has an example.