Expoerting a query

[Demona]

Hi Guys,

Is it possible to export a query from a database? I don't mean the data that the query puts out (thats easy) I want to export the syntax of the query so that I can build my queries inside my code easier.

Thanks

 

[Swannie]

Use the sql builder.

In the top left hand corner you can select between Datasheet view, Design View (standard query) and sql view.

Change it to SQL View.

You can then copy and paste the SQL into any code that you have.

 

[Demona]

duh ...

I knew that ... duh ... I guess thats why everybody makes fun of me when I have a 'me specific' blonde moment.

Thanks