I am trying to make a query that will prompt for the variable and then search the fields for that variable. I was thinking something like this...
SELECT tbl_Facility.FacilityID, tbl_Facility.HouseName, tbl_Facility.Address1
FROM tbl_Facility
WHERE (((tbl_Facility.Address1) Like "*[Search]*"));
I need the query to prompt for input. Any ideas?
Thanks
Ian
SELECT tbl_Facility.FacilityID, tbl_Facility.HouseName, tbl_Facility.Address1
FROM tbl_Facility
WHERE (((tbl_Facility.Address1) Like "*[Search]*"));
I need the query to prompt for input. Any ideas?
Thanks
Ian