Sum-table

[nat22]

Hello everyone,
I have table OdabranaOprema with 3 columns-Kolicina,Visina,Result.I would like to multiply Kolicina x Visina in 1. row and put result in Result column, than I want to do the same in the next row and so one.At the and I would like too put result of summary values from Result column in txtEverything,

how can I do it,

thanks

 

[ColinEssex]

You shouldn't store the results of calculated fields. You should calculate them in a query, as and when you need them.

You can then do the totals and sub-totals in the report.

Col

 

[neileg]

You should not hold Result in the table, you should caculate it in a qery. You need a calculated field like this
Result:[Kolicina] * [Visina]
If you want to sum the result column in a form, put txtEverthing in the footer and set the value to Sum([Result])

 

[nat22]

Hello,

I have made with query wizard OdabranaOprema Query where I put 3 columns from table OdabranaOprema - Kolicina,Visina, Result.I am the new in access, tell me please where I can put formula Result:[Kolicina] * [Visina], in code?

thanks

 

[ColinEssex]

Put it in the field name space in the query grid.

Col

 

[neileg]

Colin is right, but you need to remove Result from the table altogether, and only have it as a calculated field in the query.

 

[nat22]

Ok, I have put this in third field of Query

Result: [Kolicina]*[Visina]
and it is ok, I have values in 3.column Result(Kolicina x Visina), now, how can I make summary of all values of 3. column (Result), with Sum?
I have put in txtEverything, in ControlSource
=sum[OdabranaOprema Query]![Ukupno]
but I can not retutrn value, can you tell me what I am doing wrong

thanks,

 

[neileg]

The form will have to be bound to the query and the sum will only sum those records in the form. If you just want the total on its own you could either turn your query into a totals query, or use DSum() in a form