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!

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

Search results for query: *

  1. fkelly72

    Division by Zero Error

    Your assumptions are correct. I'm working out the margin % between Extended Price and Extended Cost on a sales table. Sometimes the cost or the price may be zero and hense the error I was receiving. the formula for margin % being (price-cost)/price*100
  2. fkelly72

    Division by Zero Error

    Genius. I don't understand the formula but it works :) Thank you.
  3. fkelly72

    Division by Zero Error

    I have a formula to calculate Margin as follows but gives a division by zero error on runtime. ({@ExtP}-{@Tot Cost})/{@ExtP}*100 I have tried using If <> 0 then 0 but still the same error.
  4. fkelly72

    Create a formula to show items outwith the selection

    Thank you LB for your help. Worked perfectly :)
  5. fkelly72

    Create a formula to show items outwith the selection

    I have an inventory database that lists my products. My database contains a field called "Last Date sold" I wish to generate a report which will prompt me for a date range and show me all items that have NOT been sold up to and during that date range. Example Item# Description last Sold...
  6. fkelly72

    IBM Thinkpad 240

    Not a major problem, more of a nuicence. I close the lid of my laptop (IBM Thinkpad 240. Model 2609) and let it go to standby mode. When I re-open and the system wakes up again, the NUMLOCK is on! Anyone else had this problem?
  7. fkelly72

    Add/Remove Programs problem

    Try re-installing Internet Explorer. I had a similar problem, when I clicked on ADD/Remove nothing happened. I re-installed IE and it fixed it...don't ask how or why!
  8. fkelly72

    Need Help Reporting Unwanted Ad Gross Violation

    I find that the unsubscribe is just another way of the companies getting more info from you as well as seeing that the e-mail address actually exists. I have found the best solution is to just delete the e-mail and enter their address in your junk-mail settings. My friends also like to bombarde...

Part and Inventory Search

Back
Top