Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2014
    Posts
    8

    Unanswered: Question about currency field

    Hi
    Can anyone tell my the proper sql syntax for creating a currency field when creating a table in access?
    I want to use sql and not query designers and I cannot find any ddl example.

    I have:
    Create Table OrderDetails
    (
    Ord_ID int NOT NULL Primary Key,
    ProductID int NOT NULL,
    UnitPrice currency,
    Quantity int NOT NULL
    )


    How do I specify currencies such as euros and rmb? also I wish to constrain amounts
    Thanks
    Last edited by nomadsoul; 11-07-15 at 20:35.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    If what you mean is "how to specify a currency format for the column of a table in Access when creating it", the answer is : you can't. The format and currency symbol depends of the "Region and Language" settings in the Control Pannel of Windows.
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Thered is the currency datatype in Access, which in a google search would be:- https://www.google.co.uk/webhp?sourc...ncy%20in%20ddl
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jan 2014
    Posts
    8
    Thanks, Allen Brown's website was helpful with currency in context of a create statemet. I'm not sure how I missed it in my own google search.

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by nomadsoul View Post
    Thanks, Allen Brown's website was helpful with currency in context of a create statemet. I'm not sure how I missed it in my own google search.
    I'm guessing thats down to not being precise enough with your search terms
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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