Recent content by shrikant

HI thanks for your reply! the below coding giving me error as syntax error query expression All.Category All.fund and in category i only need Asset ID Diff and Cusip Change only not whole category field thanks

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 Plog, Once again thanks for quick response. Please find the below SQL coding. Asset ID (Cusip)- is my One column Eodfile – is my table Category – is my another column SELECT Asset ID FROM Eodfile GROUP BY Asset ID HAVING (((IIf(Max([Category])<>Min([Category]),1,0))=1)); :)

Hi, Thanks for your reply really appreciate; but while using the first query i.e. duplicate_sub; i am getting the error. Erorr as Syntex Error (missing operator) in query expression 'Cusip' I am trying to run this query from data SQL - DataDefinition. Awaiting for the resolution...

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 Stopher, Thanks for providing me the solution! it has been worked properly... problem solved.:)

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...