>I have a grid off a table view that originally had a start and end columns with integer value. The
>client does not want to store the start/end inputs just the result of start minus end. BUT (always
>have to be a but), they still want to key it as start / end.
>
>Is there a way to build a 4 column grid:
>- Description: have a field in the table for this
>- Qty Start: text box numeric input only - not saved
>- Qty End: text box numberic input only - not saved
>- Qty Sold: have a field in the table for this - difference from the above two
>
>I already have a whole slew of temporary tables and would prefer not to create ANOTHER one!!!
>
>Thanks
>
>Pete
The problem is, unless you bind a column (i.e. give it a controlsource), you're not going to be able to show different values for each row in the grid. But I'm wondering--does your grid ever show info entered previously? If so, how do you get the start and end quantities if you don't save them?