Calculation in access

[xwings]

I'm using Access as my database, and i have a table like this;

Schedule Inseam Size Total
----------------------------------------------------------
12100 30 32 10
12100 30 32 9
13100 32 38 7
14100 34 38 8

And i wan my table do the calculation like this;

Schedule Inseam Size Total
----------------------------------------------------------
12100 30 32 19
13100 32 38 7
14100 34 38 8

Means that if its have same "Inseam" and Same "Size" it will auto calculate for me. Any idea and advise on how to do this calculation? Thanks

[MikeTheBike]

I'm using Access as my database, and i have a table like this;

Schedule Inseam Size Total
----------------------------------------------------------
12100 30 32 10
12100 30 32 9
13100 32 38 7
14100 34 38 8

And i wan my table do the calculation like this;

Schedule Inseam Size Total
----------------------------------------------------------
12100 30 32 19
13100 32 38 7
14100 34 38 8

Means that if its have same "Inseam" and Same "Size" it will auto calculate for me. Any idea and advise on how to do this calculation? Thanks

Hi
How about

SELECT Schedule, Inseam, Size, Sum(Total) as SumOfTotal FROM YourTableName GROUP BY Schedule, Inseam, Size

??

Paste this in to the query designer SQL view (with the correct table name).

MTB

[xwings]

Its Works!! thanks lot Appreciate Your Help very much!!

[MikeTheBike]

Its Works!! thanks lot Appreciate Your Help very much!!

You are very welcome

MTB