General information
Category:
Coding, syntax & commands
>>>>>>>>>
Hello all,
I have a grid show a list of record each with two numeric fields, I want to use an additional column to show the sum of that two fields on the fly. how can I do this?
Because I don't want to define that 'sum' field on tabel structure, I have following problems:
-I have try use local view, but local view have no index, so I can't use it to link to parent record.
-I have try the assign method of that tow field to update the sum column display, but it is unreliable that all row's 'sum' column display the current record's 'sum'
-I have try to create a temp table which have that 'sum' field and link to my table. And set the controlsource of column 'sum' to that temp table, but it also doesn't work.
Could you help me?
-Jasper
>>>>>>>>>>>>
Your grid could be based on a cursor with a third field taht is calculated.
SELECT *,(VALUE1+VALUE2) AS TOTAL;
FROM mytable;
INTO CURSOR Query1
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only