asked on

2 Table T1 is one to many T2 i need to update every row in T1 when I change the percent value

3 Table ( T1 is one to many T2 ) and ( T2 is one to many T3 )

I need to update every row in table T2 using VBA SQL statement

open the attach File to see the problem

Thanks a lot

SOLUTION

Fabrice Lambert

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

PatHartman

We can't look at the data but I can tell you from your description that you have a design problem. You are storing calculated data and you should not be. It is far better to do the calculation in a query so that the data is always current and you don't have to run this type of update query.

ramyooooo

ASKER

Here is the file again without Shift+Enter

I know that It is better to do the calculation in a query ,But I need to make a form that give the result In the same form

I do a lot of SQL statement before but this one is complicated a little ,You have to make
Update statement with Select statement while using Dsum statement
I hope I can find a good help

thanks a lot
N1.mdb

SOLUTION

Fabrice Lambert

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

ramyooooo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ramyooooo

ASKER

no form will violates ,I built this form for you so you can see all table in the same Time
but in real form it works individually fine
one of reason to do this Sql code
is to reduce the time while report query
and believe me it did a lot

Thanks a lot for all of you

ramyooooo

ASKER

To fix this issue you have to work around, I split my original update Vba Code into two statements.
1 - The first one is a make-table query
2 - The other one is a cross-table update query.