How to do this Form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a small mess form in msaccess for my practice. For
example
have 5 members in a mess group. Mess will calculate every month (according
to the days in each month). In the beginning of month mess members will pay
minimum amount as advance. Then they will spent from their pocket to
purchase and will write down in the book. The mess manager will calculate
everybody's due:
due to: member to mess
mess to member

Table A
Field names : number, month

Table B
Field names : names, advance, spent, days, due_before minus, due_ after_minus,
pay_to, amount, expense_per_day

pay_to = this will show e.g. "PAY TO MESS" else "PAY TO MEMBER" with if
condition.

There is line total of "advance" field and "spent" field

in "expense_per_day" field there will be a calculation as :
total_advance/total_spent
These two fields are line total of "advance"field and "spent" field.

In pay to field :
= if(advance+spent)>due_before_minus,"pay to member","pay to mess"
This one better to pick the name up in the field of name field.

should you have any questin on the above problem pls ask me.
 
Back
Top