Search results

  1. E

    NZ function and curency formatting

    Hello I really could use a hand with this as I want to get this project off of my desk I am using an sql statement to populate a report. Anyway, thanks to this board, I learned about the NZ function. This has made my reports work properly as far as the totals go. However, I can no longer...
  2. E

    stripping out decimal places

    Hi, I'm outputting an asci report to be imported by a seperate accounting package. For numbers I need the format to look like this dddddddddcc(+-) where d is dollars, c is cents, and it is followed by a plus or a minus (no parens). I am using the format command and have everything working...
Top Bottom