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