Hi I need help on a query.
For example in my Table I have (Fund Code, Date, Type A and Type B)
If i need to pick an Item based on date.
Under Item Code i have typed criteria [Enter Item code]
Under date [Enter date]
So each fund code in the table is entered on a monthly basis (month end)
So some Fund code might have started 2/15/2013 some may have started 1/15/2015
So if date chosen is 2/28/2015 for an item which started on 1/15/2015 then it should show data from Type B or if any item started since one year or more should pick data from Type A
So basically this would be a IF statement in excel, though i want to show in a query.
Any help would be greatly appreciated.
G
For example in my Table I have (Fund Code, Date, Type A and Type B)
If i need to pick an Item based on date.
Under Item Code i have typed criteria [Enter Item code]
Under date [Enter date]
So each fund code in the table is entered on a monthly basis (month end)
So some Fund code might have started 2/15/2013 some may have started 1/15/2015
So if date chosen is 2/28/2015 for an item which started on 1/15/2015 then it should show data from Type B or if any item started since one year or more should pick data from Type A
So basically this would be a IF statement in excel, though i want to show in a query.
Any help would be greatly appreciated.
G