Calculation in access forms

[miziri]

Hi,
I have in form call main inside contain filed call sum_in and subform call out inside sub form filed name out sum.
Now my question I want put valve inside out sum filed it must minus it from
sum_in in main form and put remain inside filed call rem.

see attached my database

[Rainlover]

Is this what you want

[miziri]

Hi rain lover,(nice name I like rain too)
I real thankful to and offer ur hand of help.
Your very closer to my idea ,
i want after I put values inside out_same filed in form ,I want value to change in two places
1-save new value inside rem filed
2-save new value SumOfin too.


Thanks

[Rainlover]

That is not a good idea.

If a value changes then the saved Value becomes incorrect.

Just calculate the result as you need it.

[miziri]

Hi Rainlover,
why I want to keep the change in proo table sum_in ,that balance in ever project I have when I take some thing out I need to change the balance too,
I clear to u.

thx

[Rainlover]

If you are sure that is what you want to do I will help.

Please tell what value do you want store where.

You must tell me the Table names and the Field names.

[miziri]

Hi Rainlover(nice name),
friend I want values to be store
1-table name is proo filed name is SumOfin
2-second place table name out field name is rem

friend where from,I am from iraq
Thanks

[Rainlover]

What two controls do you want me to Calculate.

It can not be SumOfin

Sorry for not understanding.

I am in Australia

[miziri]

Hi Rainlover(nice name),
friend I want value to be store table name out field name is rem


Thanks

[Rainlover]

It is late here.

I need to look more at your Table Designs.

I will write back to you in 20 hours.

[Rainlover]

If anyone else can help please jump in.

[miziri]

Hi rainlover ,
as u show ur opinion let explain about my simple database:
1-I have three table in,out,proo,I have three different project in this database
Table "in" used to enter value ever time.
Table "out" used to take some out from balance I have
Table"Proo" used as Balance of three project I have it Sum of all three.


as U know when I take some what it must reduce from balance which in table proo.
ur help and advise is highly appricate

Thanks

[Rainlover]

What you ask for is not possible with your current database design.

You need to do some research on Normalization.

Use Google. It will hepl a lot.

Also I do not believe it is a good idea for you to store these calculate values.

Sorry I am not telling you what you wnat to hear but this is the truth.

[miziri]

Hi Rainlover,
Do have yahoo or hotmail or gmail we can chat to exchange our view more.
i short what i want:
database for three projects ever project use it money.I mean I can not use money of project 1 for project 2:
therefore I have
1-table call tblin to enter money per date and amount:
2-Second table when I pay some thing,that must enter project.let me say I buy car under project 3 therefore that must detected from project three therefore when I put money in tblin i need table accumulate all three project.
when I want to buy car under project three ,I will use out at same time i will select project three from out forms then I will detect that money from it ,it will directly minus from pro3 money at same time I must have warranting MSGBOX in case i cross my balance.
my email is ssalih2000@yahoo.com
Thanks