Run A query from a Macro

[stephen]

Guys

New to this

Can any one tell me how to run a query from a macro
RunSQL allows only 255 character

Any ideas

Thanks in advance

 

[Van T. Dinh]

Check Access Help on the OpenQuery Macro action.

You can also use the RunCode Macro action to run a VBA function that uses
the DoCmd.RunSQL to execute your SQL String.

I presumed you are talking about an Action SQL String, not a Select SQL
String.

HTH
Van T. Dinh
MVP (Access)