Table

H

Hassan Merzha

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
 
J

John Spencer

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.
 
J

John Vinson

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
Click to expand...

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]
 
Top