Hi,
I have home page using MS ACCESS DATABASE 2010, with search box below example:
[IMG]file:///C:%5CUsers%5Cdeshtlel%5CAppData%5CLocal%5CTemp%5Cm sohtmlclip1%5C01%5Cclip_image001.png[/IMG]
And I have four tables like below and will be add up until 10 or more. I'm trying to create a query to combine them all. At Home Page, when I search any field, all value of that specific field from all the tables needs to pop up, below are examples.
Table 1
a b c d e f
Table 2
a b c d e f
Table 3
a b c d e f
Table 4
a b c d e f
I tried to watch tutorial video and search at any forums but could not find a way for any help. Will Highly Appreciated your help.