Access Database Edit

[Graeme]

Hi All

Where do I find details on how to EDIT vales in an Access db field (Desktop
VB.Net)? The table has 20 fields and I need enter calculated values in 5 of
these fields (the calculated values are based on data in other columns of
the record). Then I go to the next record and repeat, until the end of the
table (about 1000 records).

Any link to a helpful Web site most appreciated! I've done a lot of
searching, to no avail sofar.

Thanks!
Graeme

 

[William Ryan eMVP]

Graeme:

It sounds like an Expression Column should do it for you....

You declare a DataColumn, add the colum to your datatable and then set its
expression

DataColumn.Expression = "FirstColumn > SecondColumn" or whatever you
want..."FirstColumn * .06" etc

The nice thing about Expression columns is they work on datatables ,so it
doesn't matter what your datasource is. HTH,

Bill