Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2006
    Posts
    19

    Unanswered: need to format new field in make table query to currency

    I know that if I name a new field dollarspaid:"", I'll get a text field in the table I make. Can't I make it a currency field?

    Thanks for your help!

  2. #2
    Join Date
    May 2005
    Posts
    150
    after selecting it to be a text field... go to the bottom left of the screen and you will see a group of text boxes that allow you to enter information. Look to the one labeled "Format" and then select currency.

  3. #3
    Join Date
    Feb 2006
    Posts
    19
    If you saying to change the format in the made table, I know how to do that. I was hoping to do it in the query, as this will be part of a macro and I didn't want to have to change the format everytime before running the subsequent queries.

  4. #4
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    The query column also has a format property. In addition, you can use the Format function in the query. Details in the help file.

    tc

Posting Permissions

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