| | |
Plz Reply
Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Apr 2008
Posts: 43
Reputation:
Solved Threads: 1
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 );
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 7: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
Posts: 19
Reputation:
Solved Threads: 2
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
www.pcresolver.es
•
•
Join Date: Mar 2008
Posts: 19
Reputation:
Solved Threads: 2
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
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
www.pcresolver.es
![]() |
Similar Threads
- PLZ REPLY (IT Professionals' Lounge)
- plz review my innovative website (Website Reviews)
- Ellips arugument (C)
- Audio Driver -extreme Urgent Help Needed Plz (Motherboards, CPUs and RAM)
- MERGED: Deleting duplicates in an array (plz help me out!!!!!!!) (C)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: One to Many ?
- Next Thread: Assisteance Requested
| Thread Tools | Search this Thread |





