Querying tables in database

[gmazza via AccessMonster.com]

Hey there,
I used to work with Oracle and they had a SQL Navigator program that you
could connect to a database and then in an empty window type in statements
like:
Update Country
Set FlagNo = 2
Where Country Code like "CH*"

You would run it, it would say updated 43 rows and then you would hit the
commit buttong or type in commit and run the commit and boom it was done.

Is there something like that in Access where I can type it in rather than
choosing an Upodate query and choosing fields. I rather type cause I can say
what I want better that way.
Thanks!

 

[Daniel Pineault]

For most queries the QBE is much faster to work with.

That said you can easily switch to SQL view by right-clicking (in the area
where the tables appear) in the QBE and select SQL View. Then you can write
your SQL statement as you see fit.

Enjoy!
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Marshall Barton]

Hey there,
I used to work with Oracle and they had a SQL Navigator program that you
could connect to a database and then in an empty window type in statements
like:
Update Country
Set FlagNo = 2
Where Country Code like "CH*"

You would run it, it would say updated 43 rows and then you would hit the
commit buttong or type in commit and run the commit and boom it was done.

Is there something like that in Access where I can type it in rather than
choosing an Upodate query and choosing fields. I rather type cause I can say
what I want better that way.

Switch to the SQL window using the View menu or the tool bar
button.