Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2003
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Keeping decimal places (2000)

    I can't remember how to do this. I have a table with a field called Multiplier that is Double Fixed, and the decimal places is 4. Number 1.0000 shows up 1.0000. I also have a query that references this field. Here again the number shows up 1.0000.

    I have a report that comes from the query. On this report a have a text box where part of it says:

    ", as made by the Township Assessor and adopted or revised by the County Supervisor of Assessments. Such assessments, except those assessed as farmland under Article 10, Division 6, Section 135 of the Property Tax Code, have had a Township Equalization factor of " & [Multiplier] & " applied to all property."

    Here the number shows up 1, not 1.0000. How do I get it to show all 4 decimal places even if they are zero?

    Thanks!

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

    Re: Keeping decimal places (2000)

    Use

    ... Equalization factor of " & Format([Multiplier], "0.0000") & " applied to all property."

  3. #3
    Lounger
    Join Date
    Mar 2003
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Keeping decimal places (2000)

    Thanks so much!

Posting Permissions

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