Search results

That worked...thank you very much. I don't understand a bit of it, but copy and past with a tweak makes it work. Thank you very much for your help. Any idea how to do the same, but with current semi-annual period (1 Jan-30 Jun and 1 Jul-31 Dec)??

I am trying to include a statment in my query in which a date stored in a table is compared to a start and end date that will update itself (i.e. fiscal year dates). I will eventually embed it into an Iif statment to return a value if the selected date is either within or not within the given...