Why whenever I write a complex formula such a
SELECT tblPersonnel.First_Name, tblPersonnel.Last_Name, tblPropPass.PropPass_ID, tblPropPass.Exp_Date
FROM tblPersonnel INNER JOIN tblPropPass ON tblPersonnel.[Personnel_ID] = tblPropPass.[Personnel_ID]
WHERE (([tblPropPass].[Exp_Date]>Date()));
or the equivalent in query design, the and close the query design module, I only get part of it back.
The remaining in in query design is just :
>Date()
There is nothing else. Now the whole SQL code is still there, but since I was using query design it was frustrating
using the QD getting a Query to work, closing and opening up to find most of it missing. This is frustrating.
Any help appreciated. Thanks in advance.
R,
Lou_Reed