Hi everyone,
I have got a form in which I have got some fileds. The form as of now is not connected to any table. I have got 2 tables also which are not interconnected to each other. These tables have some common values in 1st column only. The common column is Customer's names column(1st column)
1st table 1st column has got Customer name 2nd column Customer Address and 3rd column amount spent by customer in year 2007-2008.
2nd table 1st column has got Customer name (may or may not be same as 1st table) 2nd column Customer Address and 3rd column amount spent by customer in year 2008-2009.
What I need here to make a form in which we can search for Customer's name. The customer name should be searched in both Table 1 and Table 2.
The result window then should come out with Customer's name, his address and the amount spent by him in both 2007-2008 and 2008-2009 years and the total amount spent by him from 2007-2009 (addition of both 2007-2008 and 2008-2009).
If the customer is present only in 2007-2008 then 2008-2009 box can be empty and vice-versa also.
I hope I have made myself clear also. Please revert in case of any questions.
Please suggest me how to proceed here as I am very new to Access.
Thanks in advance for your help.
I have got a form in which I have got some fileds. The form as of now is not connected to any table. I have got 2 tables also which are not interconnected to each other. These tables have some common values in 1st column only. The common column is Customer's names column(1st column)
1st table 1st column has got Customer name 2nd column Customer Address and 3rd column amount spent by customer in year 2007-2008.
2nd table 1st column has got Customer name (may or may not be same as 1st table) 2nd column Customer Address and 3rd column amount spent by customer in year 2008-2009.
What I need here to make a form in which we can search for Customer's name. The customer name should be searched in both Table 1 and Table 2.
The result window then should come out with Customer's name, his address and the amount spent by him in both 2007-2008 and 2008-2009 years and the total amount spent by him from 2007-2009 (addition of both 2007-2008 and 2008-2009).
If the customer is present only in 2007-2008 then 2008-2009 box can be empty and vice-versa also.
I hope I have made myself clear also. Please revert in case of any questions.
Please suggest me how to proceed here as I am very new to Access.
Thanks in advance for your help.