search with mulitiple tables in access data base

[saravananm]

I have created more than 20 table in single access file. I need to retrive the single data. how i can search and get the data. i want to search all the tables and get the data...

[jforbes]

I'm not exactly sure what you are attempting to do, but if you are attempting to run one query that returns results from 20 different Tables, you'll probably need to use a Union.

There is the off chance that you can get what you want done with a Join.

If you further explain what you are attempting to do, we might be able to help you better.

[Rabbit]

Also, it sounds like your data is not normalized. But you haven't provided us enough detail to help further.