Thx in advance to all. Ok this is what im trying to do- I’m keeping track of a client list with excel but im defiantly out-growing it so i moved the data over to access but I would like to add a function to one of the forms which is the following:
In the excel worksheet ill use these cells as examples:
1.”total_due”
2.”total_paid”
3.”total_bal”
4.”bal_status”
Just looking at the cell labels it self-explanatory, in the ”total_bal” cell, I added a auto sum function to give me total from ”total_due & total_paid” cells to show a balance. Now in the ”bal_status” cell I added a true or false function- if the balance was 0 then a “P” would show in the ”bal_status” cell, anything other than 0 then a “U” would show.
I would like to still do this with a form, could someone show me how to do this.
I tried using the follow code but it didnt work like I wanted it to:
If total_bal = “0” then
bal_staus = “P”
else
bal_staus = “U”
can anyone help out with this code and the autosum code to get a balance before the form saves the data?
Thx again
In the excel worksheet ill use these cells as examples:
1.”total_due”
2.”total_paid”
3.”total_bal”
4.”bal_status”
Just looking at the cell labels it self-explanatory, in the ”total_bal” cell, I added a auto sum function to give me total from ”total_due & total_paid” cells to show a balance. Now in the ”bal_status” cell I added a true or false function- if the balance was 0 then a “P” would show in the ”bal_status” cell, anything other than 0 then a “U” would show.
I would like to still do this with a form, could someone show me how to do this.
I tried using the follow code but it didnt work like I wanted it to:
If total_bal = “0” then
bal_staus = “P”
else
bal_staus = “U”
can anyone help out with this code and the autosum code to get a balance before the form saves the data?
Thx again
