By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,144 Members | 872 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,144 IT Pros & Developers. It's quick & easy.

Calculation in access

P: 4
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
Jul 11 '07 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 634
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
Jul 11 '07 #2

P: 4
Its Works!! thanks lot Appreciate Your Help very much!!
Jul 11 '07 #3

Expert 100+
P: 634
Its Works!! thanks lot Appreciate Your Help very much!!
You are very welcome

MTB
Jul 12 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.