Search results

Hi all, i am trying to make a query which will give my the result as if Sum of filed is not null.... Criteria 1) (Field Name)in Category "Asset ID Diff" And "Cusip Change" should select first then 2) Fund and Amt if Fund Amt is not zero than data will comes in query Category Fund Amt...

Hi all, i want query to find duplicate records, i have two field in one table Cusip and category cusip and category are many or duplicates but in one cusip category should be the same if not then provide the cusip which has different category used like this Cusip Category 123 R 456 P 123...

HI All, I am working on one access database wherein in query i need to use iif statement, i have one field called Age, in field criteria i need to use, IIF(weekday(DATE())="2",>"3",>"1") this if staement is not working i believe that we cant use ">" ... this type of criteria with iif, so what...