Search results

sorry for the confusion- i want to sum all the values in column-"Value1".These are two separate tables .table 2 based on months and value 2 is input by user just like value1. table 1- Class Value1 Class 0 100 Class 1 2000 Class 2 3000 Class 3 4000 Class 4 5000 Table2- Month Class Value2 1...

table 1- Class Value Class 0 100 Class 1 2000 Class 2 3000 Class 3 4000 Class 4 5000 Table2- Month Class Value 1 Class 0 1000 1 Class 1 1000 1 Class 2 1000 1 Class 3 1000 1 Class 4...

Thanks. I have one more table containing column -"Class level" (Class 0 to Class 4 but repeating across many rows) and few more fields and i want to join this table with the table i mentioned in the above comments containing columns- "Class Level" and "Values" ,join on the basis of class level...

I got the sum and volume in my query window now but i wanted it in the table window .Is it possible?

I am sorry i am new to ms access. What do i need to do after getting sum?

Yes i got the sum..it is coming in the query window only

That sum is with group by ..i just want to sum the values and use it.

Its on the basis of group by but i dont have to group the classes and sum it..is it possible to embed sum into IIF statement? Like IIF(sum(Values)>0 and sum(values)<5000,"V0", IIF(sum(values 0)>5001 and sum(values)<1000,"V1"),0)

Can you be please more specific as in what needs to be done? I tried select sum() from table but it dint work.

Thanks. First i want to take the sum of the column in the same table and then use this comparison.My table is- Class Value Sum of Value Volume C0 1000 15000 V1 C1 2000 15000 V1 C2 3000 15000 V1 C3 4000...

its like a range from 0-5000 its V0 ,5000-10000 V1 and so on. I am looking to get Volume values in the same table using case when . How to do that?

Hi, I am using access 2010. I have "classlevel" table with 2 columns-Class and Value1 .Value1 column has numeric values that i ll input from webpage (webpage to ms access connectivity). I want to sum the values of column "Value1" and i have another table-"Volume" which has 2 columns...