Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > access > answers

Viewing data from multiple tables

Newbie
  
Join Date: Jul 2007
Posts: 5
#1: Nov 30 '07
I have a database with around 10 tables, each table with 10 to 15 fields and around 2000 records. I would like to create a view of all the data from all these tables. Is it possible? If yes, how? Or is it possible only by creating a query?

Thanks in advance,

Sumith.
puppydogbuddy's Avatar
Expert
  
Join Date: May 2007
Location: Florida
Posts: 1,915
#2: Nov 30 '07

re: Viewing data from multiple tables

Quote:

Originally Posted by Sumith76

I have a database with around 10 tables, each table with 10 to 15 fields and around 2000 records. I would like to create a view of all the data from all these tables. Is it possible? If yes, how? Or is it possible only by creating a query?

Thanks in advance,

Sumith.

If you want to view data from more than one table, you must use a query. You can enhance the query's default view (datasheet) by placing the query behind a form or report.
Reply

« previous question | next question »

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,295 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved