[AccessD] Try this one again

Yeah, I did find this...thank you. For some reason...I'm guessing I didn't have it set at creation time...the format didn't follow from the table into the form, so I had to set this on the form itself. This was an easy one.
 
Thanks to your help...and a few others...I finally got this near completion. I can't believe I'd actually done this before and just forgot it.
 
I've got a couple more issues to iron out, but I think I'll put them in a separate post...one is just advice sought, and another is...well, I don't think I actually need help on it...I actually got code from this list long ago, and I just have to work it to fit this current project. Well, since it is just advice, I guess I will ask here...
 
I am using this data to print a voucher, which the witnesses will take to the treasurer's dept, and get a check. For the actual letter, would you suggest an Access report, or pumping the data out to a Word form? I figure the Access report would be the easiest, but I'm limited there w/formatting. I am currently leaning toward do this, but I am working out some spacing issues...making it work w/different data placed into the paragraphs.
 
Oh, and I do have one issue, which I will be putting in a different post...
 
Thanks again! Take care!

>>> "A.D. Tejpal" <adtp at airtelmail.in> 12/19/2009 3:15 AM >>>
    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.
-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com