Thread: Date Query
View Single Post
Old 09-22-2019, 07:53 PM   #6
Newly Registered User
Join Date: May 2019
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Aimn_4U is on a distinguished road
Re: Date Query

I still cannot manage to get this to work

Below is my SQL, Could someone please let me know where I am going wrong before my head explodes

SELECT tblUnitEquivalence.UnitEquivalence_ID, tblUnitEquivalence.[Internal Unit Code], tblUnitInternal.[Internal Unit Title], tblUnitEquivalence.[External Unit Code], tblUnitExternal.[External Unit Title], tblUnitExternal.[External Institution], tblUnitEquivalence.[Date Assessed]
FROM tblUnitInternal INNER JOIN (tblUnitExternal INNER JOIN tblUnitEquivalence ON tblUnitExternal.[External Unit Code] = tblUnitEquivalence.[External Unit Code]) ON tblUnitInternal.[Internal Unit Code] = tblUnitEquivalence.[Internal Unit Code]
WHERE (((tblUnitEquivalence.[Date Assessed])>DateAdd("yyyy",-2,Date())));
Aimn_4U is offline   Reply With Quote