If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combined information without a query
I am working on an Access Database in Access 2003. There are two main tables
that hold the most important information. There is some information that is in both, and there is also information unique to each table. I need a separate table that takes from them both--without using a query, and it needs to automatically update as I add fields to either table. Is there any way to do this? Thanks! |
#2
|
|||
|
|||
Combined information without a query
|
#3
|
|||
|
|||
Combined information without a query
it needs to automatically update as I add fields to either table.
It sounds like you are running a spreadsheet instead of a relational database. I need a separate table that takes from them both--without using a query It might could be done with a whole lot of VBA or marcos with conditions. What do you have against queries? -- KARL DEWEY Build a little - Test a little "Abbey Murrell" wrote: I am working on an Access Database in Access 2003. There are two main tables that hold the most important information. There is some information that is in both, and there is also information unique to each table. I need a separate table that takes from them both--without using a query, and it needs to automatically update as I add fields to either table. Is there any way to do this? Thanks! |
#5
|
|||
|
|||
Combined information without a query
Maybe it is more of a spreadsheet than a relational database, I wouldn't
quite know. It doesn't just contain the two tables, though, it's just that those two tables happen to have the main information. And I don't have a good relationship with queries. With this database, there are several fields I need, and when I try to get all of them in a sorted query, it becomes more of a mess than is really worth the effort. To be completely honest, I'm not the most advanced Access user, so I have limited knowledge on how to get the kinks out of my queries and poor database designs. "KARL DEWEY" wrote: it needs to automatically update as I add fields to either table. It sounds like you are running a spreadsheet instead of a relational database. I need a separate table that takes from them both--without using a query It might could be done with a whole lot of VBA or marcos with conditions. What do you have against queries? -- KARL DEWEY Build a little - Test a little "Abbey Murrell" wrote: I am working on an Access Database in Access 2003. There are two main tables that hold the most important information. There is some information that is in both, and there is also information unique to each table. I need a separate table that takes from them both--without using a query, and it needs to automatically update as I add fields to either table. Is there any way to do this? Thanks! |
#6
|
|||
|
|||
Combined information without a query
On Tue, 18 Dec 2007 07:41:01 -0800, Abbey Murrell
wrote: Okay, that's fine. If I shouldn't be keeping the information in more than one table, is there a way to export a table with subdatasheets that would show the subdatasheet data in the exported file (in Excel)? It is perfectly straightforward to export a *QUERY* to Excel. If you're assuming that you must have a distinct table in order to export, that assumption is wrong. John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|