Search results

ShaneMan Again I was fortunate enough to get some advice. I used this: Private Sub Total_Enter() Total = IIf(IsNull(Amt1), 0, Amt1) + IIf(IsNull(Amt2), 0, Amt2) + IIf(IsNull(Amt3), 0, Amt3) End Sub I haven't tried your way yet. Also, would I enter it like below????? Private Sub Total_Enter()...

OK More Problems Not that I have used Larry's suggestion and thinking everythings peachy, reality bites my butt. Adding the fomula to properties page works great. I did that for all 20 Amt's I had and each one works. I now have to total the column. I thought I could just use this formula for my...

Thanks to all that tried to help. Thanks also to Larry. Your suggestion worked best for my situation.

This is a "fill-in" form. Connected directly to the corresponding database table. There are no queries. Any more suggestions?

Hello... I am a newbie to Access or any database for that matter. So please be gentle. I'm in the process of writing an automotive invoicing database and have gotten stuck early in the game. On my form I have Qty1 - Mat1 - and Amt1 fields placed from my database. In Amt1 I would like to typein...