Hi,
How do I create a table with currency field, format is "Standard" and Decimal place is 0 by using SQL CREATE TABLE command?? for example, once I enter 245500, the field will be auto change to 245,000, instead of 245500.
Below is my SQL command,

CREATE TABLE TestTable (UserName VARCHAR(20), Job VARCHAR(20), Salary Currency, Status VARCHAR(20))


I'm using access database.
pls advice.