I am trying to obtain values from a database and ive tried using SQL and a datagrid but nothing seems to be happening except run time error 6153.
What i am trying to do is obtain the value from a column 3 and match it to the text in column 1.
e.g I have 4 records
dave Cost = £40
phil Cost = £20
george Cost = £30
jamie Cost = £10
i also need the values to be obtained during each load as the database field will be updated
thx in advance