Field not Updating

[lana_faith]

hi folks... I wonder if I could get a little more help with my database, since you all have been so helpful in the past. I'm on the home stretch here, but one of the simple things is stumping me.

I have a form named [Payroll] which is supposed to calculate total commissions for our employees automatically. I've done the hard parts of filtering the data by repID and by install date and then sorting the products sold out by commission. all I'm trying to do now is give a grand total at the bottom of how much commission this employee has earned on this paycheck. Sound like a simple sum operation to me, but I've tried several different iterations of the function in my control box, and all of them yield a blank box. It's like the field isn't updating or something... I'm completely at a loss as to what's going on here. I'll attach my database here if you'd like to take a quick look... maybe someone can see a problem that I missed.

thanks in advance!

Lana F CallView attachment DB1Zipped.zip

 

[Fear Naught]

Part of the problem (and thisi s after a only looking for a couple of minutes) is the control source of the hidden text boxes on the right of the payroll form are wrong.

You have the following in the countbasic text box:

=DCount("ProductSold","PayrollbyRepID","ProductSold = 1")

But you do not have a table or query called PayrollbyRepID hence you are getting errors.

What is that DCount() function trying to do?

 

[CEH]

Hate to say it.... But I'd start over..... Look at your relationships. Why a "make table" query on payroll? MANY fields in payroll table that shouldn't be there... Calculated fields are usually not stored in tables. Do them in queries.

 

[Fear Naught]

I have to agree totally with CEH. Regret just about to go on holiday for 2 weeks or I wuld have had a go at re-doing the database structure for you.

Good luck with it.