I read through the parts of the manual that applied
but I might be missing something here.
I have a table where I'm trying to query the date with
a conditional statement. As you'll see , if 3 was the
condition then the statement should result in a list
of any entries made <= current date.
It just is not working.
Second table (created just for query since this is
going into a web app)
Then the records in the table are
CountBackID = 30 , CountBack = 30
CountBackID = 21, CountBack = 21
CountBackID = 7, CountBack = 7
I thought my statement should be like this:
From Entry_Table, CountBack_Table
if CountBackID = 1
Date_Sub(Curdate(), interval 1 day) <= EntryDte
elseif CountBackID = 3
Date_Sub(Curdate(), interval 3 day) <= EntryDte
I'm not sure if the "if CountBackID" is wrong. Can I
not use the value in the record, or perhaps I'd need
to define a user variable?