Results 1 to 3 of 3

Thread: Query

  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Query

    Hi
    In query,
    How can I make a new column using Currency format (money), but the column is null.

    I used
    AmtPaid: Null

    Then I create the table, the type of the AmtPaid is Text type. I want it is Currency format. Please let me know, thanks.

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    To create a Table in SQL syntax you can do something like this

    Code:
    CREATE TABLE TableName
    (amtPaid Currency);
    But im not enitrey sure that this is what your after can you be more specific

  3. #3
    Join Date
    Mar 2005
    Location
    Phoenix AZ
    Posts
    56
    Wouldn't it be simpler to have the data type in the table be currency and have it's default value be zero? Maybe I'm not understanding your problem correctly.

    Ben

Posting Permissions

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