Obtaining Value from a database or datagrid

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


Who is Participating?

Improve company productivity with a Business Account.Sign Up

We're going to need a little more information than this.
Your question will best be explained with an example
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.