[AccessD] Try this one again

    You are most welcome John! For forced display of two decimal positions, just make sure that format property is also set as desired (e.g. Standard, Fixed or Currency)

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: John Clark 
  To: Access Developers discussion and problem solving 
  Sent: Friday, December 18, 2009 21:47
  Subject: Re: [AccessD] Try this one again


  Well A.D., I think you are officially my hero today! ;o)
   
  First of all, as soon as I saw your code...specifically the change to the SQL of the query...I regained my memory. This is exactly what I had done in the past, and I had totally forgotten about it. So, because I had done it that way before, and I am pressed for time, I went this way again...and it worked...for the most part it worked.
   
  Now I am on to something I totally did not foresee...something I've never run into before. I am having simple arithmetic problems now
   
  (A) The biggest problem...decimals aren't showing up properly. I've got the number type setup as double w/2 decimals, and I am still seeing "0.2" and "15" instead of "15.00"
   
  and
   
  (B) It doesn't seem to want to perform the addition of the standard fee. The witness gets mileage, based on the going rate, multiplied by their distance, and this is working. But, they also get a stipend of $15.00, and this isn't working right now. 
   
  I'm not real worried about this last one...yet...because I'm guessing it is something dumb that I am missing or doing, and I've just got to go back and proof my work for a mistake.