Search results

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

the form does not require [Base_Curr] field here. I want the Option65 click to identify that if the table [Conv_Curr_if_other_than_base] is left blank then it should automatically identify the [Base Currency] field which is in [Fund Information] table and by matching up by lookup with the field...

thanks brian, somehow the intellisence is not working here. I had ammended all the fields as required. Had also chenged the Query field [Base_curr] but somehow i guess its ignoring the field. Any idea what would be the problem! Attached the ammended DB again.

Brian, had tested already with Me.[] but did not work. I guess [] is used when i have spaces in text of table or field. Does it still not work even if give brackets? I had tested without space and without [] but no output still!! Dlookup code seems to be perfect but didnt know whats more...

Thanks Cameron, I did tried in figuring out myself, but somehow it ends up with an error. The form is for making new entry, so necessarily i have to link it with table. I had attached the db for your review. what i require is when i click in Option65 button, and if [Conv Curr if other...

i need the base as table. just wanted that query line to be on the code to pickup. I dont know how lookup, dlookup works on code. Can you please provide me with the complete code in line with sample code provided below. Thanks.