Need Help

[muhammadinam9]

Hi



I have MS Access 2007 form for that can you guide me for it. In that I have three fields

NET SALE
SALE TAX
GROSS SALE

NET SALE and SALE TAX figures i will put manually but i want the real time answer of =GROSS SALE+NET SALE +SALE TAX on form also can you tell any me how to lock gross sale amount field (box) so no one can put any value


Thanks

[June7]

Do you mean you want: =[NET SALE] + [SALE TAX]

Textbox with expression cannot be edited by user. If those are your actual field names, place them between [] because they have spaces. Better naming convention would be: NetSale or Net_Sale

[muhammadinam9]

Thanks for your reply I have another question

Its not giving me total until i fill all the fields



I put under control source " =[emp11]+[emp22]+[emp33]+[emp44]+[emp55]+[emp66]+[emp77]+[emp88]+[emp99]+[emp100]+[emp511]+[emp611]+[emp711] "

[June7]

Arithmetic with Null results in Null. If you want a total even when some fields are Null, handle Null with Nz()

=Nz([emp11],0) + Nz([emp22],0) + ...

This looks like non-normalized data structure and will probably give you lots of issues.