Solved

ACCESSS

Posted on 2013-01-17
9
256 Views
Last Modified: 2013-02-15
I ALREADY CREATED A TABLE WITH MANY FIELDS .. CAN I CREATED ANOTHER TABLE AND PULL INFO "COPY" OUT FROM A NEW ONE ONT THIS ONE I WOULD LIKE TO CREATE SUBDATASHEET. HOW CAN I DO THAT?
0
Comment
Question by:gabgar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
9 Comments
 
LVL 66

Accepted Solution

by:
Jim Horn earned 250 total points
ID: 38789670
Dude, turn off the ALL CAPS.

>CAN I CREATED ANOTHER TABLE
Yes, you can have as many tables as you want.

>AND PULL INFO "COPY" OUT FROM A NEW ONE
Not sure what you mean by INFO "COPY".   If you want to copy contents of a table into a new one, the query SQL would go something like this:

SELECT * INTO YourNewTable FROM YourOldTable

>I WOULD LIKE TO CREATE SUBDATASHEET.
Tell us what your needs are.
0
 
LVL 26

Assisted Solution

by:jerryb30
jerryb30 earned 250 total points
ID: 38789684
A query created from the original table will have the same properties (mostly) as a table for forms, reports, etc.
As in: Select field1, field2, field4 (etc) from yourTable.
So, any updates to the original table will contain any updates.

This can be used as source for a sub-form.

Is that what you want?

(Use of all caps in your question is not necessary, and can be upsetting to the eyes.)
0
 

Author Comment

by:gabgar
ID: 38790027
Sorry for the caps.. Wont do it again.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:gabgar
ID: 38841848
I've requested that this question be closed as follows:

Accepted answer: 0 points for gabgar's comment #a38790027

for the following reason:

Prompt response
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 38841846
The question was answered two ways.  Please explain why this is being closed without awarding points.
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 38841849
The question was answered two ways.  Please explain why this is being closed without awarding points.
0

Featured Post

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question