Create Table

[prithaa]

Hello, If I want a table with decimal then what is te syntax I should use to create the table. I have doubt about the data type to be used "decimal(10,2)" Is the following right? Create Table Sales (Amt decimal(10,2)) Thanks Prithaa

[pmarfleet]

Have you tried it?

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[prithaa]

Hello, Yes I have tried it and it gives me field definition error. I think the problem lies in declaring right kind of data type . decimal(10,2) or numeric(10,2) doesn't work. Pritha

[pmarfleet]

The syntax you gave in your original post works for me. There must be another error in your code. Have you posted all your code?

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[Pete OHanlon]

When posting a question like this, you may want to include information such as the database you are using. It could be that you we try something on SQL Server that works, and you think we're looking at Access.

Deja View - the feeling that you've seen this post before.

[venkat vuppala]

try this create table( , , , .................., .................., .................., )

[prithaa]

Hello, Thanks for your replies I am using this in Access.The statement Create Table Sales (Amt decimal(10,2)) is written in Access. I get the error Syntax error in field definition. Prithaa