Recent content by fkelly72

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

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

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.

Thank you LB for your help. Worked perfectly :)

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...

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?

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!

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...