Hello Team, am having a challenge with my SQL statement. I will appreciate any help towards correcting it
SQL = "SELECT * FROM Room"
WHERE
Room.FirstName Like '*" & [Forms]![RoomCustomerSearch]![txtFirstname] & "*'"_ & "
AND Room.LastName Like '*" & [Forms]![RoomCustomersearch]![txtLastname] & "*'
AND Room.PhoneNo"_ & " Like '*" & [Forms]![RoomCustomersearch]![txtPhoneNo] & "*'"