Click here to Skip to main content
14,360,820 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hi
I want to set formula in access database field.
eg.
my tabel fields are M1, M2 M3, Total
i want show addition of M1,M2,M3 in Total Field
Pls Help Me.

Thanks
Bhausaheb Funde.
Posted
Updated 30-Aug-11 22:21pm
v2

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

SELECT (M1 + M2 + M3) AS Total FROM myTable


Or

INSERT INTO myTable (M1, M2, M3, Total) VALUES (@M1, @M2, @M3, @M1 + @M2 + @M3)
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100