I have a query in MS Access. It holds two fields:
I want a third field that calculates a value based on the two fields above. I need it to do it based on this method:
If the NCyearActual is 'N1' and the StartDate is between 1st September to 31st December (in this calendar year) then show 'Nursery 2' - else, show the value held in the NCyearActual field.
I've tried a few things but I can't get it to work.
Can someone help me with this one please?
Your help would be much appreciated.