Recent content by Wheezy

Yes, that was the trick. I didn't want to have to block other users from the system, but I guess I'll have to now. THANK YOU, very much!

My main database form has worked perfectly for 8 years, and suddenly quit showing the data in the table. If I know the name I am looking for, I can search it. But, when I open the Form that used to have all my clients and their info listed. I get a blank form, with a 1 of 1 showing at the...

So, the IIf statement I wrote is drawing its value from outerspace, because the Net Sales amount is not filtered or harnessed by criteria, and .01% of $757,000 is not $599,000. I have attached "snagit" snapshots of what I am looking at. So, The Reps earn a percentage of what the work that...

Okay, I have my query formula working to list the Quarters when each job was sold. However, when I enter criteria so that only the "First" Quarter is queried,for instance, the commission formula ignores the filter completely. IIf([NetSales]>=5000,([NetSales]*.02)) The above formula...

You are the master of all! That did the trick. Thank you kindly for your time and expertise. Merry Christmas.

I'm creating a sales commissions report, where I need to be able to include a Bonus Summary at the bottom of the Detailed Report. This Summary must include Amounts: Monthly, Quarterly and Annually. I have the formulas written for the Bonuses in a Query by Sales Rep: ex.)...