PDA

View Full Version : How do I run SQL commands in Access?


RZetlin
July 25th, 2002, 22:54
Is there a way to run SQL commands in Access?

It is a pain in the @ss typing in the record fields one by one.

ohmybaby
July 26th, 2002, 03:26
You can go to my site www21.brinkster.com/huuhung to see more.What command you want to use?Insert into or select * from or something else . If you need more,let mail to me .I am rarely go to forum.

RZetlin
July 26th, 2002, 04:38
Originally posted by ohmybaby
You can go to my site www21.brinkster.com/huuhung to see more.What command you want to use?Insert into or select * from or something else . If you need more,let mail to me .I am rarely go to forum.

:confused:

I don't get it. I don't need SQL commands for Brinkster.

I need SQL commands for Access. Is there a place in Access where I can type in the SQL commands.

Is there a placed in Access where I can type commands like:

Update Customer_Table set Price=23 where ID='100'

OR

Insert INTO Customer (Name, Age) Values ('John',23)

ShADoWFLaRe85
July 26th, 2002, 06:40
I'm pretty sure you can create queries either by using the Wizard or in Design View. Just create a new query from the queries menu.