• ado-712642 (4/5/2014)


    SSC thank you for your reply. I just tried using this in my table and am a bit confused. If my table structure is like this, what would my query be like:

    Table name: tblLatLongRecords

    Fieldnames for where clause: Latitude, Longitude

    Field names I need to get back: ID,Name

    So on a regular statement we would do something like: SELECT ID,Name FROM tblLatLongRecords WHERE ....

    Slightly different thing, the query lists out all points defining a polygon, but you are asking for all points in a list which are inside a polygon, so WHERE....is the polygon?