Table Hassan Merzha 22.08.2006 10:47:01 Hi I have table look like this: Station Line Section Lenght EFC (EFCC) Bellacorick Bellacorick-J46 12.30 1.40 1.40 Bellacorick Bangor-Erris-J46 0.10 0.00 0.00 Bellacorick Belmullet-J46 16.60 1.90 1.90 Question 1:I want below EFC to see the sum and also below (EFCC) i want to see the sum of (EFCC)? Question 2: In EFC Colum i want it to have combo box that contane value "0" so i can change any field in EFC to "0" and that will also can the sum? Thank you guys

Re: Table "John Spencer" <spencer[ at ]chpdm.edu> 22.08.2006 11:15:14 First you can't do that in a table. The data in a table is all the same. So do you need to do this in a report or on a form (or even in a query)? There are solutions for each of these, but the solutions differ. For instance, if you were doing this in a query you could use a union query to display the data and a total. HOWEVER, doing it in a query would mean that the query would not be updatable. Union queries display data, but don't allow you to change the data. "Hassan Merzha" <HassanMerzha[ at ]discussions.microsoft.com> wrote in message news:488871AC-FF30-421B-AFA6-9032E5F38BB9[ at ]microsoft.com... [Quoted Text] > Hi > > I have table look like this: > > Station Line Section Lenght EFC (EFCC) > > Bellacorick Bellacorick-J46 12.30 1.40 1.40 > Bellacorick Bangor-Erris-J46 0.10 0.00 0.00 > Bellacorick Belmullet-J46 16.60 1.90 1.90 > > Question 1:I want below EFC to see the sum and also below (EFCC) i want to > see the sum of (EFCC)? > > Question 2: In EFC Colum i want it to have combo box that contane value > "0" > so i can change any field in EFC to "0" and that will also can the sum? > > Thank you guys

Re: Table John Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 22.08.2006 16:25:10 On Tue, 22 Aug 2006 03:47:01 -0700, Hassan Merzha <HassanMerzha[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Hi > >I have table look like this: > >Station Line Section Lenght EFC (EFCC) > >Bellacorick Bellacorick-J46 12.30 1.40 1.40 >Bellacorick Bangor-Erris-J46 0.10 0.00 0.00 >Bellacorick Belmullet-J46 16.60 1.90 1.90 > >Question 1:I want below EFC to see the sum and also below (EFCC) i want to >see the sum of (EFCC)? > >Question 2: In EFC Colum i want it to have combo box that contane value "0" >so i can change any field in EFC to "0" and that will also can the sum? > >Thank you guys Don't confuse data STORAGE (done in tables) with data PRESENTATION (done on Forms or Reports). They are different tasks and use different tools. CReate a Report based on your table, and use its Sorting and Grouping properties to create sections on which you can put the calculations. John W. Vinson[MVP]