Still working in Access.
My customer has a pre-existing app that needs to be updated so the library title list is updated with various verbiage.
Here is the code:
INSERT INTO NEw_Title_List (title, author, isbn,published_date, importedtitles, titlereceivedwithin10years, titlereceiptdate)
SELECT otitle, oauthor, oisbn,opublished_date, oimportedtitles, otitlereceivedwithin10years, otitlereceiptdate
Iif (importedtitles = 'Y' AND titlereceiptdate < DateAdd("yyyy", +1, Date()), '10 percent upcharge,
Iif (importedtitles = 'Y' AND titlereceivedwithin10years= 'Y' AND titlereceiptdate < DateAdd("yyyy", -1, Date()), 'no charge'))
FROM old_list1, left join oldlist2 on old_list1.ISBN = oldlist2.ISBN
My first condition works - but, my second condition that needs to print "no charge" doesn't!
What am I doing wrong?
My dates are formatted 'mm/dd/yyyy'