Recent content by shivalee

I have re-qritten my query as sodid as criteria: SELECT sod.OBJCT, sod.FIELD1, sod.VALUE1, sod.FIELD2, sod.VALUE2 FROM sod WHERE sodid=1; And now my requirement is fulfilled. Thanks both of you. shivalee

pat and wayne, you are both trying your level best to help me out. so am I. The code which wayne has sent, I have already tried it. Please can you read the whole post, I think I have explained my question and all the types of queries I have written. MY SET OF DATA IS BASED ON THE QUERY I AM...

Hello pat. I am sending you my sod file as an attchment with this mail. it has 10 sodids. although there actually are 215. Can you please see it for me. Then you can help me out with my query as you are aware of my requirement. then we will discuss our query once again. lets not talk about the...

I think the problem is that you are not understanding my question. I shall try and explain again. Lets not take the query and try to solve it, for a moment. lets take the basic question and then try to solve it. i have a file called agr_1251. the first 12 rows correspond to the one single sodid...

As you are saying, I removed the parentheses. but in this: Where (condition 1) OR (condition 2) OR (condition 3) OR (condition 4) OR Condition 5); my where (condition 1) becomes true. and the query stops after that. my conditions 2 or 3 or 4 or 5 are never evaluated at all. The subset of each...

I totally 100% agree with you, you are absolutelt right and correct. but that is where my problem starts. I know what i want and that is why I wrote that query. I know my business rules as well as my output. But what I dont know is HOW? Even if we leave aside for a second the point what you are...

I have studied all queries harder...yours and all mine. I tried running them individually and looking at the results...all queries are wrong. or as I may put it...not giving me the results I want. the moment all the 3 queries encounter an "or" , it does not run that part at all. and that is not...

thanks for replying. sorry for not understanding it earlier. I have tried your concept. it had only one problem, it was giving a lot of duplicate rows, so i added "distinct". now it is giving the same 5 records it is giving via my query. i also have the same query written another way: SELECT...

i have a form which has 9 combo boxes. each combo box value when selected inturn runs a parameter query. i need to write a code wherein if zero (0) rows are returned it should not show me an empty sheet, else show a message saying, no rows found for this. any suggestions,...please help! shivaleee

if this is not the way i should run the complex query, then i do not have any idea how it would be done otherwise. please suggest the query. please suggest the change in the query. thanks a ton for ur help

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, strSheetName, strFile here strsheetname is the name of the access table in which u shall import your excel file. strFile is the excel file you r wishing to import, u can give the whole path. i am attaching my code for your help...

thanks for replying. this query of mine is working and working perfectly. as internally it is working as "And" such as values of low and then with outer it is working as "or" it returns me 5 rows, which i have rechecked in the database and they are returning me the correct answer. secondly what...

i have this query: SELECT agr_1251.AGR_NAME FROM agr_1251 WHERE (((agr_1251.OBJECT)="s_tcode") AND ((agr_1251.FIELD)="tcd") AND ((agr_1251.LOW)="f110")) OR (((agr_1251.OBJECT)="f_regu_buk") AND ((agr_1251.FIELD)="fbtch") AND ((agr_1251.LOW)="2" And (agr_1251.LOW)="3" And (agr_1251.LOW)="11"...