How to run a query in Ms-Access 2000

[ralamo]

I've written a query in a notepad. I want to test whether it works or
not. I don't find any option to run user written queries in in
Ms-Access 2000. When i ckick on 'Queries' tab, it gives option to
'create query in design view' and 'create query by using wizard'. There
is no option for the user to write his queries on his own instead of
building it using those utilities. If anyone know how to write our own
queries and test them in access-2000, pls inform. It will be a great
help. Thank you.

[Tanis]

ralamo wrote:

I've written a query in a notepad. I want to test whether it works or
not. I don't find any option to run user written queries in in
Ms-Access 2000. When i ckick on 'Queries' tab, it gives option to
'create query in design view' and 'create query by using wizard'. There is no option for the user to write his queries on his own instead of
building it using those utilities. If anyone know how to write our own queries and test them in access-2000, pls inform. It will be a great
help. Thank you.

Copy your query from Notepad. Open up the query design grid. Click on
view. Click on SQL view and paste your query there. You will of course
need the table and field names to be in the DB

[ralamo]

Thank you so much. Yes .... i'm ableto run the query but some errors.
But it's ok. Now i know how to run user written queries. Thanks again.

[pietlinden]

you could, of course, create a new query inside Access, hit the SQL
button, and type away...

or you could get the SQL scratchpad from ADH...

[ralamo]

Thanks for the reply. I got a way to do this. Tanis gave the solution.
i got that working. So, I'm following it. Anyway thanks.