HELP Please! Merge Records In Access
Jan 11, 2007
I need some to PLEASE point me in the right direction.
I have a database of magazine articles that are listed like this:
Magazine Date Article
Time 2003-01 Iran War
Time 2003-01 Pres Campaign
Time 2003-01 Polution
Time 2003-02 Senate Race
Time 2003-02 New Cars
Time 2003-02 Cold Wave Hits
I need to merge that down to look like this:
Time 2003-01 Iran War,Pres Campaign,Polution
Time 2003-02 Senate Race,New Cars,Cold Wave Hits
Can anybody help?
View Replies
ADVERTISEMENT
Jun 9, 2014
Is there a way to merge duplicate/similar Access 2010 records into one record?
I have an Access table with 1,000 duplicate records, although they are similar and not exact duplicates. As you can see below, some records contain information that other records do not. Yet, the primary key is the same for all duplicate records. I want to find a way to merge data from filled cells of duplicate records into empty cells for each duplicate record. I do not want to concatenate the data (i.e. combine last and first name, etc.). I only want to fill empty cells if there is a match for it in a duplicate record. I will delete the newly exact duplicate records later. Short of correcting the records by hand.
Example
Code:
LastName FirstName SSN Address Phone Email
Doe John 123-45-7891 123 Anywhere St. NULL john(at)gmail.com
Doe John 123-45-7891 NULL (123)456-7890 NULL
Desired Result
Code:
LastName FirstName SSN Address Phone Email
Doe John 123-45-7891 123 Anywhere St. (123)456-7890 john(at)gmail.com
Doe John 123-45-7891 123 Anywhere St. (123)456-7890 john(at)gmail.com
View 2 Replies
View Related
Mar 8, 2006
I have a table with the following fields for each record:
StudentID CsrID Average FinalExam
For most StudentID/CsrID there are two records, one with the Average and a null FinalExam, one with the FinalExam and a null Average. If there is no FinalExam, no record is generated.
How can I merge the records so that I will have only one record for each StudentID/CsrID that includes both the Average and the FinalExam?
View 2 Replies
View Related
Sep 26, 2007
Hi I hope someone can help.
I have a table with records in like the follwowing examples.
Record 1
ID - 1
AccountID - 123
Name - Mr Smith
Address - 38 The Close
PetName - Tilly
Record 2
ID - 2
AccountID - 123
Name - Mr Smith
Address - 38 The Close
PetName - Chloe
Record 3
ID - 3
AccountID - 124
Name - Mr Jones
Address - 49 The Avenue
PetName - Francis
I would like to be able to run an update query that would merge the records with the same Account ID by PetName so that my table would now look like this
Record 1
ID - 1
AccountID - 123
Name - Mr Smith
Address - 38 The Close
PetName - Tilly & Chloe
Record 3
ID - 3
AccountID - 124
Name - Mr Jones
Address - 49 The Avenue
PetName - Francis
So record 2 would have been removed but the Pet that belongs merged with an & into record 1.
It's had me puzzled me for some time.
Thanks to any replies in advance.
theoldskoolninja
View 8 Replies
View Related
Jul 15, 2014
The highlighting shows what records are duplicates. Those are the only records that need to change. Not every field of the record is a duplicate, and I don't want some of the fields that are duplicates to be combined.
If the result I want is not possible, or way too complicated for me is there a way to just have this: [URL] ....
Basically, I'm just getting rid of the sum within the merged record.
Note: I want this information to show up in a report. I put the information in the images into excel just to make it easier to show. Also, if you end up testing this yourself could you provide me with your Access document.
View 1 Replies
View Related
May 12, 2005
Hi I wonder if anyone can help? I have looked through prevous posts and cant find any answers that fit what I need to do. For reference I am using Access 97 and Word 97.
I want to be able to have a client record open in a form and click a button and for that particular record to merge with a preformatted word doc. I have created a query that gives me all the fields I need (as they are over multiple tables) and I can successfully combine this into a mail merge. But it currently takes *all* the records and I want it to only do the current one. I also want user to be able to click a button somewhere on the form that automates this process for him. Is this possible?
I have investigated transfertext and filled in what I think I should have but it seems to do nothing. It creates another (unopenable) file in the same folder as the word doc and does nothing else. But I am using the 'export word for windows merge' in the tranfertext action?
If I can only crack this I will be happy! Many thanks in advance for any help
DD
View 3 Replies
View Related
Jun 24, 2013
I have a report that is derived from a table (tblDocs) the structure of the table is:
EmpId docType docDate comments
(number) (number) (Date) (text)
This table will have several entries for each employee. There will only be a few times that a comment will be entered. On my report, I will have a field for the comments and I would like ALL of the comments for each employee combined into one text box in the report There will be blank entries in most of the records). I think the control source for this might be a query, but not sure. I set the properties of the text box to can grow.
View 3 Replies
View Related
Dec 7, 2005
Hi, could anyone teach me how to do this? Thanks in advance!
Here is the result of a query I have:
PersonEmail ProductAmountCategory
AA@hotmail.comApple10Fruit
AA@hotmail.comOrange20Fruit
AA@hotmail.comPen30Office
BB@hotmail.comApple15Fruit
BB@hotmail.comOrange25Fruit
BB@hotmail.comPen35Office
CC@hotmail.comApple18Fruit
CC@hotmail.comOrange28Fruit
CC@hotmail.comPen38Office
What I need to do is the develop a report, in a format like:
Person:A
Category
FruitAmountOfficeAmount
Apple10Pen30
Orange20
Total30Total30
Do this for A,B,and C and send the individual report in via email to them. To me it looks like a mail merge, but I don't know how to manipulate the data and put it into the layout. My real data has a lot of data, about 100 person, and about 60 product that falls into two categories. Is there anyway easy and fast way to do this? Please help! Thank you very much!
View 2 Replies
View Related
Nov 19, 2004
I am using a query for a word mail merge and would like to maintain the formating from Access into Word. Is this possible and if so how. If not, anyone have a clue how to do it in Word... I am importing the date and would like it to be long version (Friday, November 19, 2004) and it's giving me the short version (11/19/04),
Thanks and have a great weekend!
View 2 Replies
View Related
Jul 25, 2007
I am wanting to create letters in word to go out to trainees which lists the courses they are booked on. I have successfully created a query which has a parameter under the 'Trainee ID' field, where I put in the trainee ID number and the query pulls out the courses that particular trainee is on. However, when I try to mail merge this into word, it works well BUT...insists on creating a new document/letter for each course the person is booked on.
What I wanted was for it to list the courses below the trainee name but can't for the life of me get it to do this
Anyone got any ideas ? I would appreciate any help with this
View 1 Replies
View Related
Jun 11, 2005
I am trying to merge data with MS Word, but am getting problems. I
only seem to be able to merge a single record. Can anyone help pls as this
is quite urgent
Thanks
barnettpaul@gmail.com
View 2 Replies
View Related
Oct 11, 2006
Hi,
I have created a mail merge from a query in Access and it works fine if you run it from word but I would like to know how to automate the mail merge from Access using the Command button. Please can someone advise.
Thanks
Alex
View 5 Replies
View Related
Aug 16, 2007
Ok here is my question. I have two column that I am trying to merge. The first column I have set to be two digits. The second column is set to be three digits. The problem is if the first digit in the second column is a 0 it gets dropped once the two columns are merged. How do I stop this from happening. I need the merged columns to be 5 digits.
Thanks,
View 1 Replies
View Related
Aug 17, 2007
I want to use an Access Table for a mail merge but when i try to use the merge option I get a pop up asking for a password. I put in my administrator password for the database and it tells me I dont have acess to the database. It has something to do with the passwords i put on the database.
Anyone have any ideas to what I need to do to get this to work?
View 1 Replies
View Related
Feb 11, 2008
Currently there is a MS Word application that runs a MS Access query to generate data for the Mail Merge with a document.
Does anyone have a suggestion as to how this process can be optimized? Specifically, looking to reduce the amount of time required to produce letters (best practices).
Thanks.
View 1 Replies
View Related
Jan 3, 2005
Happy New Year everyone-- I am trying to use an Access query to create mailing labels- Is there anyway to keep them alphabetized or sorted?
Thanks!
View 3 Replies
View Related
Jan 15, 2005
Hello- I am building an access database for a non- profit that does alot of mailings. My question is how to handle the people that live in the same house- ie: John and Mary Smith? Both have their own entry in the database, but I want to be able to send them one mailing to John and Mary Smith, rather than two addressed to each individually. Addressing the mailings to "Residents of", or something similar is to impersonal as many of them are donors.
Any good ideas how to handle this?
Thanks for any help!
View 1 Replies
View Related
Feb 27, 2005
I have numerous word docs that I need to mail too. What I am tring to acheive is how to link an active record that has been entered on a input form by the user to the various word docs as corressponding letters. This is how the user currently chooses which letter to use However, they are obviously entering the data manually as there is no merge facility.
The merge data is stored in a query called "QryMerge" is there any VB code that I could add to this
Private Sub cboReport_Change()
On Error GoTo Err_Handler
Dim stDocName As String
If [cboReport] = "L1" Then
Dim taskid As Long
Dim str As String
str = "winword.exe " & "D:DataFrm_L1.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "L2" Then
str = "winword.exe " & "D:DataFrm_L2.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "M" Then
str = "winword.exe D:DataFrm_M.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "N1" Then
str = "winword.exe D:DataFrm_N1.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "N1A" Then
str = "winword.exe D:DataFrm_N1A.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "N2" Then
str = "winword.exe D:DataFrm_N2.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "N3" Then
str = "winword.exe D:DataFrm_N3.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "O" Then
str = "winword.exe D:DataFrm_O.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "P1" Then
str = "winword.exe D:DataFrm_P1.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "P2" Then
str = "winword.exe D:DataFrm_P2.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "R" Then
str = "winword.exe D:DataFrm_R.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "S" Then
str = "winword.exe D:DataFrm_S.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "T" Then
str = "winword.exe D:DataFrm_T.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "U" Then
str = "winword.exe D:DataFrm_U.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "V" Then
str = "winword.exe D:DataFrm_V.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "W1" Then
str = "winword.exe D:DataFrm_W1.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "W2" Then
str = "winword.exe D:DataFrm_W2.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "W3" Then
str = "winword.exe D:DataFrm_W3.doc"
taskid = Shell(str, vbMaximizedFocus)
ElseIf [cboReport] = "X" Then
str = "winword.exe D:DataFrm_X.doc"
taskid = Shell(str, vbMaximizedFocus)
Exit Sub
Err_Handler:
Beep
MsgBox "You have cancelled this message."
Exit Sub
End If
End Sub
I Would also be greatful for any help on how to convert a tick box on an access form to dislay ticked/unticked in a wordmerged doc.
Regards, Steve
View 14 Replies
View Related
Apr 18, 2006
I'm using a query that selects all customers from a Customer table who haven't made any payments for a particular week and then sends a letter to them.
I would like to use a command button on a form which the user can press and then view the letters for all the customers- they would only have to specify the week.
Is this possible?
Thanks
View 3 Replies
View Related
Jul 11, 2013
Am using below code for generating set of pdf files in a desired folder..similarly I have another code, which generates another set of pdf file in another folder.. Count and Filename is identical in both the folders and I need to merge the file names with identical names together....separate binder file would also work..
Private Sub Command14_Click()
Dim strDefaultPrinter As String
strDefaultPrinter = Application.Printer.DeviceName
Set Application.Printer = Application.Printers("Adobe PDF")
[code]....
View 4 Replies
View Related
Feb 18, 2015
I am preparing a Word document for a mail shot, and need to import data from my access file. I am trying to build a formula that will take a field from the Access file and, if it is true, print some data.
So far, I have =IF(Schedule 2014=40,full page). Schedule 2014 is a column in the query I am using in this mail merge, 40 is an amount of money in that column and full page is the text that should appear in the Word document. The result I am getting is!Syntax Error, 2014 .
The remainder of the information I am merging is working well. I am asking for the 40 to appear in the relevant recipient's letter which is fine, but I want it to print full page before it (or half page for 30, or quarter page for 20)
View 1 Replies
View Related
Sep 27, 2012
I have to coordinate a dbase in the US, one in the UK, and one in the KSA. I have multiple documents that may, or may not, be in each of the three dbases. I need to merge all three, and maintain them so that the document additions, as well as any changes associated with that document, (i.e. "revisions"), are updated. Having looked at access and having read through some of the Access forum questions, I understand that it can do that, but after having identified the information from the dbases that will go into access, I'm trying to establish a consistant process for maintaining and updating it. Can I export my information from each of the dbases, into an excel spreasheet, (1 for US, 1 for UK, and 1 for SA), and have the access dbase search for the document number, compare the data following the document number, and if it's the same ignore it, and if it's different, update it?
I'm trying to muddle through this and get access and excel to do as much of this as possible, as it's a very tedious and time consuming process to manually check each one, one or two times a week.
View 8 Replies
View Related
Apr 22, 2013
merging seven tables with the same layout, but different information from different groups into one main table.
View 6 Replies
View Related
Jul 13, 2005
Lads,
Here's a little problem that is driving me nuts. I know what is wrong and yet I can't fix it!
I have an Access D/B and a mail merge word doc which gets its data from a table in the database. Now the date is in the correct format in the table i.e. uk/european format. The 5 of january 2005 would be 05/01/2005.
However when this gets into the word doc it changes to USA format i.e. 01/05/2005.
Not very desireable! how do I fix it?
Thanks in advance,
Liam
View 4 Replies
View Related
Aug 22, 2006
I am wanting to do away with access 97 on a few computers here at work but we cant afford to buy everyone office 2003. Before I buy us access 2003 for a computer I need to know if word 97 will do a mail merge with access 2003. Or could I just buy Office 2003 package for the few computers and it will work that way for a bit more money. I think there would be a compatability issue...
View 3 Replies
View Related
Dec 13, 2006
Hi
I have written an application which uses a query for the current record and then opens a Word document, merges this record and shows the merged document for the user.
all works fine using Office 2003 - when i try it on a pc with Office 2002 - it diesn't work. Something is happening - WINWORD.EXE is running on the process list. But the document doesn't open. I have added the Microsoft Office 10 Office Library to the references but still no joy.
It's a killer - all testing was done on Office 2003 and now a key user wants to use the app - on 2002 and it doesn't work
Any ideas?
cheers
View 1 Replies
View Related
