currency function in MS Access 2007 (correct syntax, etc.)

[burningman]

i am using MS Access 2007, i am currently creating a table, and my SQL script is as follows: CREATE TABLE Rep (RepNum Char(2) PRIMARY KEY, LastName CHAR(15), FirstName CHAR(15), Commission Currency (7, 2) in the line "Commission Currency (7, 2)" i got a message that says "syntax error in CREATE TABLE statement." please help.

[orange]

I'd try dropping the (7,2)

The CURRENCY data type

The CURRENCY data type is used to store numeric data that contains up to 15 digits on the left side of the decimal point, and up to 4 digits on the right. It uses 8 bytes of memory for storage, and its only synonym is MONEY.
The following CREATE TABLE statement shows the CURRENCY data type that can be used to create a table through the Access SQL View user interface or through the Jet OLE DB provider and ADO.



CREATE TABLE tblCurrencyDataTypes (
Field1_CURRENCY CURRENCY,
Field2_MONEY MONEY)

[Xipooo]

I'd try dropping the (7,2)

this -----^

You don't need to specify field size for a currency field.

[burningman]

I'd try dropping the (7,2)

got it! thanks a lot!

[burningman]

this -----^

You don't need to specify field size for a currency field.

got it! thanks a lot!