hey,
i'm trying to assign the result of a SQL query (that should return a single integer value) to an integer VB Variable.
I thought that the following would work, but it does not :s
====================================================================================================================
SQL = "SELECT Motorway_Speed FROM Countries WHERE Country = (SELECT Country FROM Locations WHERE L_Name = '" & Sheet1.Origin.Value & "')"
Speed = Db.OpenRecordset(SQL)
====================================================================================================================
anyone can enlighten me on this one?
thanks
olo
Bookmarks