My database has 3 tables (among others):
RelapseTimes: Fields include S1,T2,U3,S4,W4,RID
Relapse: Fields include RID,MID
Clinic; Fields include MID,Date
Basically, all I want to do is get all the values in the RelapseTimes table where the date is within the last 12 months (i.e. after the date 'a').
If I include 'date' as a field in RelapseTimes then I have no issue executing the SELECT statement;
strSQL = "SELECT S1,T2,U3,S4,W4 FROM RelapseTimes WHERE RelapseTimes.Date >= #" & a & "# "
However, I have split my tables so that I do not store the same data in multiple tables but cannot get my SELECT statement to work.
Date is now only in the Clinic Table.
I am receiving a 'no value given for one or more parameters' error when attempting to execute this code
strSQL = "SELECT S1,T2,U3,S4,W4
FROM RelapseTimes
WHERE RelapseTimes.RID=Relapse.RID AND Relapse.MID=Clinic.MID AND Clinic.Date >= #" & a & "# "
Any suggestions?
Thanks.
Bookmarks