Results 1 to 2 of 2
  1. #1
    carl g.
    Guest

    Formatting Queries (Access 97 SR-2)

    Hi All,

    Does anyone know a quick way to format Double fields in a Query as "Standard" with 0 decimal places?

    Regards,

    Carl

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formatting Queries (Access 97 SR-2)

    Each field in a query has a format property, but you can coerce the format by using a CLng() function on each since you want zero decimal places.
    Charlotte

Posting Permissions

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