Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Posts
    9

    Unanswered: CREATE TABLE SQL Command -> Data type Currency

    hi,
    How do I create a table with currency field, format is "Standard" and Decimal place is 0 by using SQL CREATE TABLE command??
    pls advice!!

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: CREATE TABLE SQL Command -> Data type Currency

    Originally posted by charon
    hi,
    How do I create a table with currency field, format is "Standard" and Decimal place is 0 by using SQL CREATE TABLE command??
    pls advice!!
    What DBMS?

  3. #3
    Join Date
    Jan 2003
    Posts
    9

    Re: CREATE TABLE SQL Command -> Data type Currency

    Originally posted by andrewst
    What DBMS?
    I'm using access database....

  4. #4
    Join Date
    Jan 2003
    Posts
    9

    Re: CREATE TABLE SQL Command -> Data type Currency

    Originally posted by andrewst
    What DBMS?
    This is my SQL statement:

    cSQL = "CREATE TABLE " & strPhase & " (Lot_Number VARCHAR(20), Built_Up_Area VARCHAR(20), Selling_Price CURRENCY money NOT NULL, Status VARCHAR(20))"

  5. #5
    Join Date
    Jan 2003
    Posts
    9
    If use the Currency without setting the format and the decimal place,
    The format of the currency field and the decima place is $1,222,333.00 and 0 respectively. What I want the format is Set to Standard and the decimal place is 0, the result i want is 1,222,333 without the $ sign in front.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •