I have the created a query in Access 2013 and named it qryTest3. The values for some of the fields are hard coded. I want to be a ble to pass in the parameters for the following fields in my query: SK.Skill, SK.NumberLevel, and TmpDate. I want to pass in the values/parameters from my VBA code and place the results in a recordset. How do I do that? Do I have to rewrite my query? Below is a the sample of my query:
SELECT AV.Tech_Name, AV.TmpDate, AV.AVAILABILITY, AV.NOTES, AV.Skill_ID, SK.Skill, SK.Level, SK.NumberLevel
FROM qryAvailability2NEW AS AV INNER JOIN tblSkills AS SK ON SK.SkillID = AV.Skill_ID
WHERE SK.Skill in ('Programmer') AND SK.NumberLevel <= 2
AND (AV.TmpDate >= '2/3/2015' AND AV.TmpDate <= '2/5/2015');
Thank you very much in advance.