473,414 Members | 1,757 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > microsoft access / vba > questions > search with mulitiple tables in access data base

Join Bytes to post your question to a community of 473,414 software developers and data experts.

search with mulitiple tables in access data base

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...
Jan 23 '15 #1
2 932
jforbes
1,107 Expert 1GB
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.
Jan 23 '15 #2
Rabbit
12,516 Expert Mod 8TB
Also, it sounds like your data is not normalized. But you haven't provided us enough detail to help further.
Jan 23 '15 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
access data base onto a web page
by: Joe101 | last post by:
Question: How to put access data base onto a web page?
Microsoft Access / VBA
8
Error on Insert on a Access Data Base
by: slb813 | last post by:
Hello, I am having a problem that I can't seem to work out. I am running Apache 2.2 on a Windows XP platform, using PHP5. I am attempting to insert a row into a MS Access data base with a PHP...
PHP
3
dnb
how save data in diffrent language in access data base
by: dnb | last post by:
Hi Friends, I make project in vb6.0. i need some data save in diffrent language in access data base.like 1st field in english and 2nd field in hindi etc.......... How can i do this? Plz give me...
Visual Basic 4 / 5 / 6
24
Question For Microsoft Access Data Base
by: joeldault | last post by:
Question For Microsoft Access Data Base -------------------------------------------------------------------------------- I am Trying to create a single formula that would do the following: If...
Microsoft Access / VBA
1
Ms access data base security
by: gerryis2000 | last post by:
Hi, kindly guide me on how to solve this security problem. i set a passord to the data base and seems to work well. but since several people use the data base and know the passord, i think its risky....
Microsoft Access / VBA
0
Update access data base from excel , based on primary key.
by: Aravind555 | last post by:
Hi, I like to update access data base from excel , based on primary key. also i like to know how to get customized report(query) in Excel where i may need to do only refresh in excel Thanks...
Microsoft Access / VBA
0
Vkas
How to insert simple record in a Access data base 2007
by: Vkas | last post by:
I have a default .aspx form i HAVE 3 TEXT BOX 1 DROPDOWN LIST IN MY DEFAULT PAGE. a access data base file at locaion C:\asp.netdb\feedback.accdb I want to insert the values into the access...
ASP.NET
5
Some Ideas on Tables my data base has got very messy and I dont think my tables are r
by: Wornout | last post by:
I have built 3 data bases now and still think there is another way can someone come up with a better Idea. I have A) Base recipe B)Base Recipe name C)Ingredients D)Recipe E) Recipe Ingredients Both...
Microsoft Access / VBA
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Computer Hardware
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
tracyyun
Discussion: How does Zigbee compare with other wireless protocols in smart home applications?
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
General
0
Couldn’t get equations in html when convert word .docx file to html file in C#.
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
C# / C Sharp

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!