related to ms-access

[Soundarya]

hi,

i have to enter 2 values that is 140/ and some value. i am able to insert and update 140/ and the value to the database.

The problem is with retrieving?

so when i am doing retrieving, both 140/ and the value which is in database is getting retrieved.

i need only the value, but not 140/

how can I do this in labview?

Thanks in Advance

Regards

Soundarya

[MikeS81]

Hi Soundarya,

why do you always start a new thread? It's the same as here.

You can use a "SELECT" query to get the value you want.

SELECT "yourvaluescolumnname" FROM "yourtablename" WHERE ?='140'

Mike