cx Grid and cxLookupcombo
Posted on 2009-02-20
In my cxgrid I have a field defined as cxLookupcombo (gets data from another table).
Table looks something like this (4 fields) :
WTF ACC PLUS MINUS
One 10 11,55
Two 16 20,00
Seven 10 22,16
The field ACC is the cxLookupcombo.
Now I want to send this data to another table.Example:
If the cxLookupcombo value is 10 then I would sum all the values in the table where cxLookupcombo displays 10 (in the example above it would be 33,71) and insert it into another table.I would like to insert the footer value under the field PLUS also.Database is access (I am using ado)
How is the queery supposed to look like?