What do you expect StrComp() to do? The expression StrComp(string1, string2) returns -1 if string1 < string2, 0 if string1 = string2, or 1 if string1 > string2.
If your purpose is to compare two strings (or string variants), or here the contents of two columns, use the equal ("=") operator, in a WHERE clause or, even better, use an INNER JOIN operation to link both tables.
I've tried the select you mentioned i dont get any results back, i dont understand why though because both tables have matching fields can it be because of the nulls ??? I placed a picture in my post before with the data. Thanks.
Ive been doing that selecting one condition at a time so when i get the first window to match in both tables even though there are only 41 records in the Route tbl i get a result of 189 and then when i add window 3 to the condition i get 5 rows and when windows 4 and 5 come in, i get nothing i dont know what i am doing wrong here ?