I have a query which searches the given value from 5 columns in a table? Don't ask me why:blush:. Is there way to get the column name where the value was found? I'm using Access as a database.
Printable View
I have a query which searches the given value from 5 columns in a table? Don't ask me why:blush:. Is there way to get the column name where the value was found? I'm using Access as a database.
This returns the name of the first (0) column in a DataSet:
VB Code:
Dim sColumnName As String = DS.Tables("sample").Columns.Item(0).ToString