Select Query

[dichotomous]

I have a list box returning values from a query. The query is based on my table called: tblinductionexpiry.

The table captures induction dates of Contractor Employees. The PK is; Induction_ID.
Contname_ID ...fk and
ContEmplName_ID fk.

Obviously contname_ID shows up evertime one of their employees is inducted.

I want my list box query to return only one contractor name between a date range.

I'm going to use the list box to print a report for that contractor showing his employees expired inductions - that part is easy.

I can't for the life of me figure out how to return only one contractor's name when it's connected to so many induction records.

 

[sneuberg]

I don't see where the dates are so I don't know what would be in your FROM clause but otherwise I think


SELECT DISTINCT Contname_ID
FROM tblinductionexpiry ??????
WHERE SomeDate Between Forms!TheFormName!StartDate And Forms!TheFormName!EndDate

Or some sort of aggregate query might do it for you.