473,667 Members | 2,528 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Merge records

2 New Member
Does anyone know how to merge similar records into one record?

Example;



Table 1

FName LName Data 1 Data 2 Data 3 Data 4
Joe Smith 1 2

Table 2

FName LName Data 1 Data 2 Data 3 Data 4
Joe Smith 2 3 4


Desired query output
Table 1-2

FName LName Data 1 Data 2 Data 3 Data 4
Joe Smith 1 2 3 4
Dec 11 '07 #1
2 1638
puppydogbuddy
1,923 Recognized Expert Top Contributor
Does anyone know how to merge similar records into one record?

Example;



Table 1

FName LName Data 1 Data 2 Data 3 Data 4
Joe Smith 1 2

Table 2

FName LName Data 1 Data 2 Data 3 Data 4
Joe Smith 2 3 4


Desired query output
Table 1-2

FName LName Data 1 Data 2 Data 3 Data 4
Joe Smith 1 2 3 4

See this link:
http://office.microsoft.com/en-us/ac...860631033.aspx

Click the hyperlink
Append data from two or more similar tables or queries into a single table
Dec 11 '07 #2
openroad
2 New Member
Thanks! Perfect! Worked like a charm after some study and a few mishaps
Dec 12 '07 #3

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

Similar topics

1
3161
by: Morris | last post by:
Does anyone know whether it is possible to effect a mail merge to MSWord using VBScript in an asp file? I know it is possible to produce a doc file and force a download using Response.ContentType = "application/msword" Response.AddHeader content-disposition","attachment;filename=myfile.doc" but can I interate through a bunch of records and produce, say, a separate invoice for each one by merging? I know how to iterate through the...
8
9511
by: Squirrel | last post by:
Hi everyone, I've created a mail merge Word doc. (using Office XP) , the data source is an Access query. Functionality I'm attempting to set up is: User sets a boolean field to true for each person for whom a mail merge letter is desired. The query reads address info from the table for each record where is true.
0
1325
by: DS | last post by:
Hi Guys (and ladies): I have a parameter query in A2K that asks for records based on certain criteria. It returns the name and address fields of each record. I usually get about 5 to 10 records from the query. I then use this query as the basis for a Word mail merge but instead of printing out letters, I email the records. The problem is that when I do a merge and ask it to merge for email, it lumps all the records into one email. Any...
1
1863
by: Paul Wagstaff | last post by:
Hi folks, Please forgive me - this straddles Access & Word '97 If I could, I'd send a (approx 1000 records) recordset to Word, mailmerge it & save the new document. However, Word's mailmerge process stops at around 400 records (I've only sent it a handful of fields for testing). My current method involves a saved ..doc with its datasource saved as my Access query. Thro' Access VBA I:
9
20850
by: DraguVaso | last post by:
Hi, I have two DataTables (our DataViews or whatever that will suit the best for the solution). I want to merge these two DataTables the fastest as possible, but they have to be merged one table after the others: First all the recors of DataTable1, and afterwarths the records of DataTable2. Does anybody has any idea how to do this? The purpose it that it goes as fast as possible! DataTable2 can have up to 15.000 records, DataTable1...
2
1751
by: Mamidinx | last post by:
Hi, With the MERGE statement I am using in DB2 it rolls back all the way if an error is encountered. Is there a way to save each of the encountered exception but proceed to the next data record rather than a complete rollback? Any help regarding this would be appreciated. Thanks in advance, mamidinx
6
4642
by: crealesmith | last post by:
Firstly, I have no problem with mail merging to Word, VB code for that works perfectly. On one mail merge I need to merge 15 fields of data that are from 3 seperate records. The 3 records are all in the same table. If I use a control source that is selecting the 3 records, all of the data is shown but spread over 3 pages in the mail merge, but needs to be listed together in one paragraph. Is there anyway of looping through the 3...
1
4750
by: Bmack500 | last post by:
I'm using the following subroutine. The two different XML files are identical with the exception of three additional records in the second one. One has 450 records, and the other has 453. After merging, I get 903 records. I guess what I expected was 3 records; just the differences in the two. The two tables have the exact same structure, etc.... So am I misinterpreting how to do this? It seems to me that the merge should produce only...
6
8985
by: amitabh.mehra | last post by:
I want to trap errors (RI errors), if any, that might turn up during merge in DB2. Is there some feature like the one in Oracle: MERGE INTO... WHEN MATCHED THEN UPDATE... WHEN NOT MATCHED THEN INSERT... LOG ERRORS INTO... I mean is there some LOG ERRORS INTO or an equivalent clause in case
1
11474
by: kirkus84 | last post by:
I am currently trying to do a multiple record mail merge through a query via a command button on a form. The query basically displays customers who have said yes to privacy. The user inputs a date into txtDate on frmDate and the clicks "View Queried Privacy Records" Once they click this it opens the query form frmPrivacy which then has a command button cmdMailmerge to perform the mail merge and print the records that result from that query. (I...
0
8459
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8367
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8889
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8790
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6206
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5677
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4202
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4372
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1779
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.