Undefined function in query

[.paul.]

Linq to sql might be easier in your situation...

[Mark@SF]

Right, I need the SQL to convert the GetAssetPrice() function into a decimal value: GetAssetPrice(20,#4/18/2019#,"ClosePrice") = 133.56

And do this for each row of data that the SQL returns.

I'm really stumped why this works in MS Access, but not in VB.Net...

[.paul.]

Right, I need the SQL to convert the GetAssetPrice() function into a decimal value: GetAssetPrice(20,#4/18/2019#,"ClosePrice") = 133.56

And do this for each row of data that the SQL returns.

I'm really stumped why this works in MS Access, but not in VB.Net...

It works in Access because you're not concatenating a string in your query. Try the LINQ queries

[Mark@SF]

Ok, thanks. I've never worked with LINQ so I'll have to do some homework...