Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rickm140

  1. rickm140

    last sale (or most recent sale) greater than zero

    I have developed a sales tax expiration report to keep track of a customer's tax exempt certificate. I now need to add a column where I show the date of the last invoice/sale greater than zero. The reason for this is because we do have invoices amount where the sale amount = $0.00. Does...
  2. rickm140

    changing Crystal report from calendar year to fiscal year

    Is this a Crystal formula or an SQL formula? If it is a Crystal formula, do the '####' specify the year?
  3. rickm140

    changing Crystal report from calendar year to fiscal year

    I have a sales report that I developed for our sales manager based on the calendar year. However, since we are on a fiscal year and not a calendar year, he would like to have it changed to reflect our fiscal year. I have two questions: #1) How do I export the crystal report with the formulas...
  4. rickm140

    Division by Zero

    Pete: thanks for your suggestion. I tried that and it worked flawlessly. Rick Meyer
  5. rickm140

    Division by Zero

    I have a 2-year sales report (YTD and MTD) that I need some help with. It shows the profit % for the grand totals which appear at the top of the report but it will not show the profit % for the detail. Every time I try to create a formula I get "Division by Zero" error message. Can someone...
See more

Part and Inventory Search

Back
Top