Plz Reply

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 401,481 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,156 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Thread Tools Display Modes

Views: 630 | Replies: 4

•

Join Date: Apr 2008

Posts: 38

Reputation: Yogesh Sharma is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

Yogesh Sharma Yogesh Sharma is offline

Offline

Light Poster

Where to write query in MS_Access

Apr 8th, 2008

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE TABLE Persons
(
FirstName VARCHAR,
[Last Name] Text,
Gender int,
[Date Of Birth] DateTime,
MaritalStatus Integer,
IsMarried Bit,
PersonalIncome Money,
HouseholdIncome Currency
);
CREATE TABLE Persons
(
FirstName VARCHAR,
[Last Name] Text,
Gender int,
[Date Of Birth] DateTime,
MaritalStatus Integer,
IsMarried Bit,
PersonalIncome Money,
HouseholdIncome Currency
);

Can u plz tell me where I have to write this Query in MS-Access to craete the Table.

Last edited by peter_budo : Apr 8th, 2008 at 6:44 am. Reason: Keep It Organized - please use [code] tags, also use proper thread title, please help this and that is not welcomed, check forum policies

•

Join Date: Mar 2008

Location: Spain

Posts: 19

Reputation: PCResolver is an unknown quantity at this point

Rep Power: 1

Solved Threads: 2

PCResolver PCResolver is offline

Offline

Newbie Poster

Re: Plz Reply

Apr 8th, 2008

You can look at and therefore add / edit sql statements by clicking the SQL view or View SQL button in the design view.

Steve
www.pcresolver.es

•

Join Date: Apr 2008

Posts: 38

Reputation: Yogesh Sharma is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

Yogesh Sharma Yogesh Sharma is offline

Offline

Light Poster

Re: Plz Reply

Apr 8th, 2008

Can u plz tell me in the more clear way,I m not getting.

•

Join Date: Mar 2008

Location: Spain

Posts: 19

Reputation: PCResolver is an unknown quantity at this point

Rep Power: 1

Solved Threads: 2

PCResolver PCResolver is offline

Offline

Newbie Poster

Re: Plz Reply

Apr 9th, 2008

This is how you do it in Access 2007. It will be similar in Access 2000 but if you want 2000 instructions please let me know.

Open your database
Select the "Create" tab at the top
Select "Query Design"
Close the "Show Table" popup
Select "SQL View"
Enter the code
Press "Run" and the table will be created.

Good luck

Steve
www.pcresolver.es

•

Join Date: Apr 2008

Posts: 2

Reputation: jenny@okcinvest is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

jenny@okcinvest jenny@okcinvest is offline

Offline

Newbie Poster

Re: Plz Reply

Apr 9th, 2008

note: in 2007, you'll need to first click the button to create a Create Table query. Then click the SQL Viewer button. Enter your sql and click run to create the table.