SELECT main.[PUAMI Reference], main.Canceled, main.[Reason for Cancelation], main.[Name of PUAMI assessor], main.[Assessment Date], main.[Month/year of Arrival], main.[GPS Coordinates], main.[Village ID], main.[Village-Area], main.[Name of Head of HH], main.[Tel No of Head of HH], main.[Family Book No], main.[Existing Situation -Economic Status ID], main.[Monthly rent USD], main.[HCR Registration No], main.[Total no of displaced family members], main.[Area of Origin], main.[Total rooms occupied by displaced family], main.[People per room], main.Nationality, main.[ID Number], main.[Existing Situation -Physical Status ID], main.[Name of House Owner], main.[Lebanese ID No], main.[Tel No of Owner], main.[Total rooms in House], main.[No of persons between 18 and 55], main.[Working people (18-55)], main.[Total Family Income Per Month]
WHERE (((main.[PUAMI Reference]) Like "*" & [forms]![Search]![PUAMI Reference] & "*") AND ((main.[Name of PUAMI assessor]) Like "*" & [forms]![Search]![PU Assessor] & "*") AND ((main.[Assessment Date]) Like "*" & [forms]![Search]![Assessment Date] & "*") AND ((main.[Village-Area]) Like "*" & [forms]![Search]![Village-Area] & "*") AND ((main.[Name of Head of HH]) Like "*" & [forms]![Search]![Name of Head of HH] & "*") AND ((main.[Tel No of Head of HH]) Like "*" & [forms]![Search]![Tel No of Head of HH] & "*") AND ((main.[Family Book No]) Like "*" & [forms]![Search]![Family Book Number] & "*")); |