<< Thanks for your input Larry. But I am using the BD grid for editing and other manipulations. I need to for the time being not make a complete logic change. >>
In that case, I think what you need to do is this: 1. Add a speed button to the form labelled "Include In Totals". 2. This button's ON CLICK EEP should store the primary key value of the current grid row somehow (I usually do this in a temporary table with a single column, defined to match the PK column). 3. Calculate your total by referencing the PK values you stored away (SUM(Column) IN Table WHERE PKColumn IN (SELECT PKColumn FROM TempTable)). You can do this in the forms variable list, or in the same EEP code in which you store away the PK value (since that's the only time you need to recalculate). 4. You'll probably need to give some way to remove an accidentally included row from the total. You can do this using the same speed button (in the grid table's ROW ENTRY EEP you check whether the PK is in the temporary table already, if so you change the caption of the button to "Exclude From Totals" and change the EEP's functionality accordingly) or with a separate button. Alternatively, you can add a column to the table itself that users can mark somehow to indicate it should be included in the total (and maybe another computed column to change the color of the included rows) but unless the table that you based the grid on is already a temporary table, this will not be multi-user safe. -- Larry
