Is ForktruckActive a Boolean Yes/No field?
If so, you might try
Code:
SELECT [1-qryAssociates-Active].Badge
, [1-qryAssociates-Active].Associate
, [1-qryAssociates-Active].Section
, [1-qryAssociates-Active].ForktruckTempLicense
, [1-qryAssociates-Active].Forktruck_2yrLicense
, [1-qryAssociates-Active].ForktruckActive
FROM [1-qryAssociates-Active]
WHERE ((([1-qryAssociates-Active].ForktruckTempLicense)<Date()-56) AND
(([1-qryAssociates-Active].Forktruck_2yrLicense) Is Null) AND
(([1-qryAssociates-Active].ForktruckActive)= True));
If you need more assistance, I suggest you post a copy of your database. If the data is private/personal, you could use names like Porky Pig, John Doe etc. We don't need real data, but more interested in the structure and logic.
Good luck.