SELECT Co_location.location_id, Co_location.cl_address,;
Co_location.cl_city, Co_location.cl_state, Co_location.cl_zip,;
Co_location.cl_country, Co_location.cl_date_turned_up,;
Co_location.cl_cabinets, Co_location.cl_racks, Co_location.cl_voicet1,;
Co_location.cl_sovereigns;
FROM dbo.Co_Location Co_location;
WHERE Co_location.cl_city = ?city

This is what it used to look like, so that the box would pop up and ask them what they would want to view based on city.