Ok I have it working now, I wont copy in the details of the Query designer, just the actual SQL, here it is:
SELECT data.test_date, tech.id, tech.tech_name
FROM tech INNER JOIN data ON tech.id = data.tech_id
WHERE (((data.test_date) Between [Forms]![query_form]![from_date_txt]
And...