Recent content by shijuantony2002

got it.. thanks for ur input.

Thanks Rabbie, it worked perfectly. Can i also change the heading of one field to what i require to be named as. For e.g. i want the field C output to be named as "DON". Also i want the SQL to be grouped by say field B.

I need to combine 5 set of queries into one. I know this should work with UNION ALL in SQL, but don't know how to place it. For e.g. the query names are query1, query2, query3, query4 and query5. Each of these queries have same set of field name, A, B & C and output may also goes similar...

well i meant exact instead. fuzzy logiz sounds new to me. can you post an example?

Hello, I know this might be a common question which you'll might had faced but still i had to query too as i am clueless on how to go about in finding a duplicate for an Input form. Had attached the db for your reference. I want the form to prompt message if the combination of multiple...

ignore the query guyzz.... i got it worked with some changes myself.

when i use this code for click on option button, the button lost focus. Am not allowed to click, what should be the problem. I had the same code working for other function. Private Sub Base_Curr_Click() strdq = Chr$(34) If Me.Base_Curr = -1 And IsNull(Me.Conv_Curr__if_other_than_base)...

Thanks for all your suggestions

Excellent!!! this worked.... thankss..

Thanks both, it didnt showed up with syntax error, but when i run the query it shows blank. Individually it shows up with the required output. Pls help!! I feel its very close to what i require. Had attached the db. You can refer the query named "Master Summary...."

I have two fields in a query, say one field name is "A" which is an output of another query linked to it and other field name is also "A" which is also an output of another query (other than above) linked to it. Now since both the field name are same "A" am not able to combine these two fields...

I need to put the following in the query expression column, can you advise, what would be wrong here. Am not good in building expression, so please correct it. Havent read in many post the Is Not Null function, so please tell if there are any alternative. Remit Bank Name : IIf(Is Not...

thanks brian, i figured out, why intellisense was not working. To refresh the intellisense i removed the link from list box and reloaded, and it worked.

I guess the main problem should be that intellisense is not identifying the object of the list box. The field [Base_Curr] is not been identified and so dlookup might not be working as the object of data member is not found. Any way out?

thanks brian, but am still stuck with my main query...