Searching Fields at Search Box from Different Tables Form not working

[Yeisha2008]

Hi,



Not really good in data base access, however i assigned on this task. I need help to run this database.

I have 4 tables (Table 1, Table 2, Table 3 and Table 4) with same field and will add up more tables with same field as well. How can I run my search box? Example Table below:

Country Color Number Percentage Population

America White 9 10% 0000
Brazil White 18 8% 1111
Zimbabwe Black 2 3% 2222

If i will find Percentage of America at Search Box. All percentage of America From Table 1 to Table 4 will come up. Badly needed your help.

Thanks

[orange]

??? I have no idea what you are asking. It sounds that you may have a database design issue.
Why not tell us what your application is about, so we have some understanding of your situation? Then ask specific questions as necessary.

[Rawb]

You can either use a Union Query to combine all the tables together, or you can use VBA to programattically search through each Table individually.

Example Union Query:

SELECT 'Table 1' AS [TableName], [Country], [Color], [Number], [Percentage], [Population] FROM [Table 1] 
UNION SELECT 'Table 2' AS [TableName], [Country], [Color], [Number], [Percentage], [Population] FROM [Table 2] 
UNION SELECT 'Table 3' AS [TableName], [Country], [Color], [Number], [Percentage], [Population] FROM [Table 3] 
UNION SELECT 'Table 4' AS [TableName], [Country], [Color], [Number], [Percentage], [Population] FROM [Table 4] 
WHERE [Country]='America'

[Rawb]

I agree with orange though. If all four Tables contain the same type of data, they should really be combined to just one.

[Yeisha2008]

I agree with orange though. If all four Tables contain the same type of data, they should really be combined to just one.

Hi Thanks for trying to help. @Rawb: Dunno how to use VBA
@ Orange: Please see attached image... trying to attached the dbase,
but always error.

[Yeisha2008]

If i will multi search destination all their information will pop up on the table below from all tables.
like if i will search Cayman Island, type and area codes. all information will pop up! Thanks so much!

[orange]

I have acc2003, so a acc2010 accdb is of no value to me. Others may be able to help.
I still have no idea what you are trying to do.