SELECT [Map index].[Map_Number], [Map index].Surveyor, [Map index].[Map_Name], [Map index].County, [Map index].NY_County, [Map index].[Map_Type], [Map index].Town, [Map index].NY_Town, [Map index].Address, [Map index].Street, [Map index].[Drawing_Number], [Map index].[Project_Number], [Map index].[Block], [Map index].[Lot], [Map index].[Group], [Map index].[Folder], [Map index].[Latitude], [Map index].[Longitude], [Map index].[Map_Date]
FROM [Map index]
WHERE ((([Map index].Surveyor) Like "*" & [Forms]![DW_Form]![Surveyor] & "*") OR (([Map index].Surveyor)=[Forms]![DW_Form]![Surveyor]) Is Null)
AND ((([Map index].State) Like "*" & [Forms]![DW_Form]![State] & "*") OR (([Forms]![DW_Form]![State]) Is Null))
AND ((([Map index].County) Like "*" & [Forms]![DW_Form]![County] & "*") OR (([Forms]![DW_Form]![County]) Is Null))
AND ((([Map index].Town) Like "*" & [Forms]![DW_Form]![Town] & "*") OR (([Forms]![DW_Form]![Town]) Is Null))
AND ((([Map index].Address) Like "*" & [Forms]![DW_Form]![Address] & "*" ) OR (([Forms]![DW_Form]![Address]) Is Null))
AND ((([Map index].[Map_Type]) Like "*" & [Forms]![DW_Form]![Map_Type] & "*") OR (([Forms]![DW_Form]![Map_Type]) Is Null))
AND ((([Map index].[Project_Number]) Like "*" & [Forms]![DW_Form]![Project] & "*") OR (([Forms]![DW_Form]![Project]) Is Null))
AND ((([Map index].[Drawing_Number]) Like "*" & [Forms]![DW_Form]![Drawing] & "*") OR (([Forms]![DW_Form]![Drawing]) Is Null))
AND ((([Map index].[Map_Name]) Like "*" & [Forms]![DW_Form]![Map_Name] & "*") OR (([Forms]![DW_Form]![Map_Name]) Is Null))
AND (
((([Map index].[Street]) Like "*" & [Forms]![DW_Form]![Street] & "*") OR (([Forms]![DW_Form]![Street]) Is Null))
OR ((([Map index].[Street_2]) Like "*" & [Forms]![DW_Form]![Street] & "*") OR (([Forms]![DW_Form]![Street]) Is Null))
OR ((([Map index].[Street_3]) Like "*" & [Forms]![DW_Form]![Street] & "*") OR (([Forms]![DW_Form]![Street]) Is Null))
OR ((([Map index].[Street_4]) Like "*" & [Forms]![DW_Form]![Street] & "*") OR (([Forms]![DW_Form]![Street]) Is Null))
OR ((([Map index].[Street_5]) Like "*" & [Forms]![DW_Form]![Street] & "*") OR (([Forms]![DW_Form]![Street]) Is Null))
OR ((([Map index].[Street_6]) Like "*" & [Forms]![DW_Form]![Street] & "*") OR (([Forms]![DW_Form]![Street]) Is Null))
OR ((([Map index].[Street_7]) Like "*" & [Forms]![DW_Form]![Street] & "*") OR (([Forms]![DW_Form]![Street]) Is Null))
OR ((([Map index].[Street_8]) Like "*" & [Forms]![DW_Form]![Street] & "*") OR (([Forms]![DW_Form]![Street]) Is Null))
OR ((([Map index].[Street_9]) Like "*" & [Forms]![DW_Form]![Street] & "*") OR (([Forms]![DW_Form]![Street]) Is Null))
OR ((([Map index].[Street_10]) Like "*" & [Forms]![DW_Form]![Street] & "*") OR (([Forms]![DW_Form]![Street]) Is Null))
)
AND (
((([Map index].[Name_1]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_2]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_3]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_4]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_5]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_6]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_7]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_8]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_9]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_10]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_11]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_12]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_13]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_14]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_15]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_16]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_17]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_18]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_19]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
OR ((([Map index].[Name_20]) Like "*" & [Forms]![DW_Form]![Name] & "*") OR (([Forms]![DW_Form]![Name]) Is Null))
)
AND ((([Map index].Map_Date) = [Forms]![DW_Form]![Map_Date]) OR (([Forms]![DW_Form]![Map_Date]) Is Null))
AND (
((([Map index].[Block]) Like "*" & [Forms]![DW_Form]![Block] & "*") OR (([Forms]![DW_Form]![Block]) Is Null))
OR ((([Map index].[Block_2]) Like "*" & [Forms]![DW_Form]![Block] & "*") OR (([Forms]![DW_Form]![Block]) Is Null))
OR ((([Map index].[Block_3]) Like "*" & [Forms]![DW_Form]![Block] & "*") OR (([Forms]![DW_Form]![Block]) Is Null))
OR ((([Map index].[Block_4]) Like "*" & [Forms]![DW_Form]![Block] & "*") OR (([Forms]![DW_Form]![Block]) Is Null))
OR ((([Map index].[Block_5]) Like "*" & [Forms]![DW_Form]![Block] & "*") OR (([Forms]![DW_Form]![Block]) Is Null))
OR ((([Map index].[Block_6]) Like "*" & [Forms]![DW_Form]![Block] & "*") OR (([Forms]![DW_Form]![Block]) Is Null))
)
AND (
((([Map index].[Lot]) Like "*" & [Forms]![DW_Form]![Lot] & "*") OR (([Forms]![DW_Form]![Lot]) Is Null))
OR ((([Map index].[Lot_2]) Like "*" & [Forms]![DW_Form]![Lot] & "*") OR (([Forms]![DW_Form]![Lot]) Is Null))
OR ((([Map index].[Lot_3]) Like "*" & [Forms]![DW_Form]![Lot] & "*") OR (([Forms]![DW_Form]![Lot]) Is Null))
OR ((([Map index].[Lot_4]) Like "*" & [Forms]![DW_Form]![Lot] & "*") OR (([Forms]![DW_Form]![Lot]) Is Null))
OR ((([Map index].[Lot_5]) Like "*" & [Forms]![DW_Form]![Lot] & "*") OR (([Forms]![DW_Form]![Lot]) Is Null))
OR ((([Map index].[Lot_6]) Like "*" & [Forms]![DW_Form]![Lot] & "*") OR (([Forms]![DW_Form]![Lot]) Is Null))
OR ((([Map index].[Lot_(Block_2)]) Like "*" & [Forms]![DW_Form]![Lot] & "*") OR (([Forms]![DW_Form]![Lot]) Is Null))
OR ((([Map index].[Lot_2_(Block_2)]) Like "*" & [Forms]![DW_Form]![Lot] & "*") OR (([Forms]![DW_Form]![Lot]) Is Null))
OR ((([Map index].[Lot_3_(Block_2)]) Like "*" & [Forms]![DW_Form]![Lot] & "*") OR (([Forms]![DW_Form]![Lot]) Is Null))
OR ((([Map index].[Lot_4_(Block_2)]) Like "*" & [Forms]![DW_Form]![Lot] & "*") OR (([Forms]![DW_Form]![Lot]) Is Null))
OR ((([Map index].[Lot_5_(Block_2)]) Like "*" & [Forms]![DW_Form]![Lot] & "*") OR (([Forms]![DW_Form]![Lot]) Is Null))
OR ((([Map index].[Lot_6_(Block_2)]) Like "*" & [Forms]![DW_Form]![Lot] & "*") OR (([Forms]![DW_Form]![Lot]) Is Null))
)
ORDER BY [Map index].[Street];