Good morning,
I have a Crystal Report that works great but my management has requested that I create the same query in Access 2003 for multiple users. I have created the query in Access 2003 but I can't figure out how to re-write the formula in the Expression Builder.
[ul][li]I have used the Expression Builder for simple functions but I have not done anything in VBA.[/li][/ul]
[ul][li]I would like create an extra column in the query design view and use the Expression Builder to add the formula below. [/li][/ul]
Can someone tell me the correct way to write the above formula?
Thank you in advance for your help.
Clay
I have a Crystal Report that works great but my management has requested that I create the same query in Access 2003 for multiple users. I have created the query in Access 2003 but I can't figure out how to re-write the formula in the Expression Builder.
[ul][li]I have used the Expression Builder for simple functions but I have not done anything in VBA.[/li][/ul]
[ul][li]I would like create an extra column in the query design view and use the Expression Builder to add the formula below. [/li][/ul]
Code:
if {'Purchase_Order_Rescheduling_'.IMS Need Date} IN cdate (2014, 01, 01) to cdate (2014, 01, 31)
AND {@PO DUE DATE} IN currentdate to cdate (2013, 12, 31)
or {@PO DUE DATE} IN AllDatesToYesterday then "Consider Pushing out to Jan 2014" else
if {'Purchase_Order_Rescheduling_'.IMS Need Date} IN AllDatesToYesterday
AND {@PO DUE DATE} <= {'Purchase_Order_Rescheduling_'.IMS Need Date} then "Review for Expediting";
Can someone tell me the correct way to write the above formula?
Thank you in advance for your help.
Clay