Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Decimals in Crosstab Query Results (2003)

    On the startup form of the attached mdb, please select Gennaio(January) for both the "from" and "to" month combo boxes and 2007 as the year.
    Is it possible to make the QueryFermi3SGB query return decimals(i.e. 468.5) as the QryOreFermsgb2 query does?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Decimals in Crosstab Query Results (2003)

    - Remove Val from the expression for Totale and ConteggioDIF so that the expression becomes

    Nz(Sum([V2].[OREF]),0)

    - Set the Format property of both columns to General Number or to Fixed.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Decimals in Crosstab Query Results (2003)

    Perfect!!! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Thank you Hans

Posting Permissions

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