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
|
|||
|
|||
merge fields
i have two databases with one primary id key (social security number of
clients). Each database contains different information that I want to merge into one database that is keyed by the social security number. -- daniel w hayden |
#2
|
|||
|
|||
merge fields
On Wed, 16 Nov 2005 08:35:20 -0800, "daniel hayden"
wrote: i have two databases with one primary id key (social security number of clients). Each database contains different information that I want to merge into one database that is keyed by the social security number. Two DATABASES - two separate .mdb files containing multiple tables, forms, reports, etc.? or two TABLES within a .mdb file? And do you want to permanently convert the two tables into one table, or just combine the information for a report or display? More details please! John W. Vinson[MVP] |
#3
|
|||
|
|||
merge fields
Thanks. It worked fine. But now I have to generate a report with the queried
data, but when i go to the report the append query does not appear as an option (just the linked tables that do not contain the query data together). How do I get around that? -- daniel w hayden "KARL DEWEY" wrote: Link the tables and then append. "daniel hayden" wrote: i have two databases with one primary id key (social security number of clients). Each database contains different information that I want to merge into one database that is keyed by the social security number. -- daniel w hayden |
#4
|
|||
|
|||
merge fields
Link the tables and then append.
"daniel hayden" wrote: i have two databases with one primary id key (social security number of clients). Each database contains different information that I want to merge into one database that is keyed by the social security number. -- daniel w hayden |
#5
|
|||
|
|||
merge fields
Open the report in design view and click on menu VIEW - Properties. Type in
the name of the query as record source. "daniel hayden" wrote: Thanks. It worked fine. But now I have to generate a report with the queried data, but when i go to the report the append query does not appear as an option (just the linked tables that do not contain the query data together). How do I get around that? -- daniel w hayden "KARL DEWEY" wrote: Link the tables and then append. "daniel hayden" wrote: i have two databases with one primary id key (social security number of clients). Each database contains different information that I want to merge into one database that is keyed by the social security number. -- daniel w hayden |
#6
|
|||
|
|||
merge fields
Open the report in design view and click on menu VIEW - Properties. Type in
the name of the query in the record source. "daniel hayden" wrote: Thanks. It worked fine. But now I have to generate a report with the queried data, but when i go to the report the append query does not appear as an option (just the linked tables that do not contain the query data together). How do I get around that? -- daniel w hayden "KARL DEWEY" wrote: Link the tables and then append. "daniel hayden" wrote: i have two databases with one primary id key (social security number of clients). Each database contains different information that I want to merge into one database that is keyed by the social security number. -- daniel w hayden |
#7
|
|||
|
|||
merge fields
I tried that but it says it can't create a field list based on an action
query.?? -- daniel w hayden "KARL DEWEY" wrote: Open the report in design view and click on menu VIEW - Properties. Type in the name of the query as record source. "daniel hayden" wrote: Thanks. It worked fine. But now I have to generate a report with the queried data, but when i go to the report the append query does not appear as an option (just the linked tables that do not contain the query data together). How do I get around that? -- daniel w hayden "KARL DEWEY" wrote: Link the tables and then append. "daniel hayden" wrote: i have two databases with one primary id key (social security number of clients). Each database contains different information that I want to merge into one database that is keyed by the social security number. -- daniel w hayden |
#8
|
|||
|
|||
merge fields
On Thu, 17 Nov 2005 07:34:08 -0800, "daniel hayden"
wrote: I tried that but it says it can't create a field list based on an action query.?? An Action query such as an Append query DOES SOMETHING - it adds new records to a table when you run it. It does not provide a list of records which can be used on a Form. If you want to see the records that the Append query appended, base the Form on the table that you appended the records into. John W. Vinson[MVP] |
#9
|
|||
|
|||
merge fields
okay, sorry about the terminology....its actually two tables within one
database. I want to be able to report out data from both tables: Table 1 (Fields): ss# of customer, order, date of order, total amount, salesman Table 2( Fields): ss# of customer, name, address, city, state, zip, referral source We need a report by customer (social security number) that includes all the fields from both tables. Thus, the report should look like: John Smith (customer) 333-00-9999 (social security) Order 1 (1/1/05) $100.00 (Fred Jones, Salesman) Order 2 (5/5/05) $300.00 (Sally Orth, Salesman) 111 Main Street, Portland, OR 66666 Orion Industries (referral source) Thanks! -- daniel w hayden "John Vinson" wrote: On Wed, 16 Nov 2005 08:35:20 -0800, "daniel hayden" wrote: i have two databases with one primary id key (social security number of clients). Each database contains different information that I want to merge into one database that is keyed by the social security number. Two DATABASES - two separate .mdb files containing multiple tables, forms, reports, etc.? or two TABLES within a .mdb file? And do you want to permanently convert the two tables into one table, or just combine the information for a report or display? More details please! John W. Vinson[MVP] |
#10
|
|||
|
|||
merge fields
Build a query with both table with join on SS#. Use the query as source in
your report. "daniel hayden" wrote: okay, sorry about the terminology....its actually two tables within one database. I want to be able to report out data from both tables: Table 1 (Fields): ss# of customer, order, date of order, total amount, salesman Table 2( Fields): ss# of customer, name, address, city, state, zip, referral source We need a report by customer (social security number) that includes all the fields from both tables. Thus, the report should look like: John Smith (customer) 333-00-9999 (social security) Order 1 (1/1/05) $100.00 (Fred Jones, Salesman) Order 2 (5/5/05) $300.00 (Sally Orth, Salesman) 111 Main Street, Portland, OR 66666 Orion Industries (referral source) Thanks! -- daniel w hayden "John Vinson" wrote: On Wed, 16 Nov 2005 08:35:20 -0800, "daniel hayden" wrote: i have two databases with one primary id key (social security number of clients). Each database contains different information that I want to merge into one database that is keyed by the social security number. Two DATABASES - two separate .mdb files containing multiple tables, forms, reports, etc.? or two TABLES within a .mdb file? And do you want to permanently convert the two tables into one table, or just combine the information for a report or display? More details please! John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Lily@Insight | Mailmerge | 24 | January 15th, 2007 09:33 PM |
Form text fields are disappearing during a merge to new document. | Trevor Drew | Mailmerge | 7 | January 30th, 2006 09:35 PM |
Format problem with merge fields in word table | Jan | Mailmerge | 1 | May 20th, 2005 11:15 AM |
Can you create a multi-layered merge where certain merge fields a. | mileszat | Mailmerge | 3 | January 18th, 2005 03:46 AM |
Lost text fields in merge | CGiannini | General Discussion | 5 | June 4th, 2004 10:23 PM |