Hi I have access table like….
OrderID Price OrderDate
4123 856.41 20/01/2008
4126 -52.86 21/01/2008
4562 785.23 23/02/2009
4862 62.86 23/02/2009
MS Access query I am looking
OrderID Price OrderDate EndOfMonthDate Status
4123 856.41 20/01/2009 31/01/2008 Pass
4126 -52.86 21/01/2009 31/01/2008 Fail
4562 785.23 17/02/2009 28/02/2008 Pass
4862 62.86 24/02/2009 28/02/2008 Pass
** EndOfMonthDate column is end date of OrderDate like for January 2009 end date is 31st Jan 2009
** Status column If Price is greater than or equal to Zero than PASS else FAIL.
Any MS-Access SQL Query? Its urgant…thanks….