PC Review


Reply
Thread Tools Rate Thread

Re: Querying tables in database

 
 
Marshall Barton
Guest
Posts: n/a
 
      7th Oct 2009
gmazza via AccessMonster.com wrote:

>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.

--
Marsh
MVP [MS Access]
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: Querying tables in database Daniel Pineault Microsoft Access Form Coding 0 7th Oct 2009 11:06 PM
RE: querying tables in a different database? Klatuu Microsoft Access Queries 0 5th Jun 2008 10:04 PM
Querying the Structure of Tables in a Database Liz Microsoft Access Database Table Design 2 13th Nov 2006 04:41 AM
Querying data tables CarlosAntenna Microsoft Excel Discussion 0 18th Aug 2004 03:13 PM
querying and re-querying in form? courtney Microsoft Access Form Coding 0 20th Aug 2003 01:18 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:46 AM.