I create a querydef using the following code...
Private Sub Command74_Click()
Dim sql As String
Dim assType As String
assType = "1"
sql = "SELECT tblPeople.strPersonNINumber, tblPeople.strPersonforename, tblPeople.strPersonSurname, tblAssessments.strAssType...