Search results

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

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

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

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

Here is the attachment to the query to give more insight view to the question. I had linked the query 'Form3' to the 'Table'. If you will see, there are two fields i had added, 'Soonest Value Date' and other 'Soonest Value'(which is not linked to the table and contains the expression). The...