Merge Two Field In A Table

Apr 5, 2008

All,
I have a table with about 50,000 records. In the table I have a First Name and Middle Name field. I have created a third field called FULL NAMES.
PROBLEM: How do i combine the data from First Name and Middle Name fields into the FULL Names field in the same table.

Thanks for your help!

View Replies


ADVERTISEMENT

Merge One Field From One Table With Another Field In Different Table

Nov 23, 2011

What is the best way to do this ..merge one field from one table with another field in a different table to a new field...

View 3 Replies View Related

Merge Fields Into One Field

Aug 14, 2005

I have a table and would like to merge all the fields into one text field of the table after the insert. I'm using adp (access/sql server).

When using standard sql the null values give a problem and i don't want to use the if clause as it will give too much coding.....

View 1 Replies View Related

Can I Merge 2 Txt Fields To 1 Memo Field

Apr 6, 2006

Hi,

I have an old database for generating service reports which has:
Report No
Date
Customer
Site

In separate fields which is fine

but also

wrk1
wrk2
wrk3
etc.

with a separate field for each printed line on the page
I would like to merge all these into one memo field while retaining the previous data which goes back 15 years (it came from a MSWorks 2.0 DOS db which is the reason for the weird structure I think)

Is there any way to write a macro or code to selectively merge some but not all fields in a table?

I've already copied the db and modified it after clearing all the old data, it works fine but I'd like to have access to the old data in the new format

TIA

Kim

View 3 Replies View Related

Mail Merge Field List

Oct 25, 2014

I have a very large AccessDB application that I did not create, but am tasked with maintaining/updating. It has a letter Mail Merge with a field list that is in a .txt file on the server. I have new fields that I need to add to the list to be included in the letter. i cannot figure out how to add them? Not very familiar with Mail Merge.

View 7 Replies View Related

General :: Merge Two Database Having Same Field Name But Different Data

Sep 27, 2013

I have two db's that I want to merge. they both have the same field names, but different data and some of the have same ID's, How do I merge them?

View 1 Replies View Related

To Merge 2 Tables In 1 Table

Jan 10, 2007

Hi,
I have 2 tables which have the same variables:
1st is called "stockholm"
The other is "gothenburg"
I tried to query them but the query does not add everything, there are always missing records.

Any tips?

Thank you in advance & best regards
noah

View 1 Replies View Related

Multiple Table Merge

Sep 23, 2005

I have a database to handle both purchase orders and customer orders,

My problem is with the products.

there are six tables all with identical fields, but with different data in each, I need to be able to merge these six table into one and allow the original tables to be updated, inturn updating the merged table.

any help would be great.

View 3 Replies View Related

General :: Adding Access Field To Mail Merge?

Jun 19, 2013

Is it possible to add an access field to a mail merge without having to recreate/redo the mail merge?

View 2 Replies View Related

Queries :: Creating A Query That Will Merge Various Fields Into One Field

Jun 9, 2015

way to merge various fields from a table into just one using a query.The purpose will be for easier copying and pasting in to an email.So we have a table to stores information such as Site Contact, Address 1, Address 2, Address 3, Postcode etc.

I want to be able to run a query that will put the address in to just one box, either in the query or on a report then it's much easier to just highlight the full address and copy and paste it into an email. Rather than copying each field individually.

View 3 Replies View Related

Update MS Access Field When Mail Merge Letter Is Printed

Apr 6, 2015

I am using an MS Access 2010 table as a data source for a mail merge. I would like to update a field in the table with the date that the letter is printed. Is there a way to do this?

View 5 Replies View Related

Tables :: Merge Spreadsheet Into Already Created Table

Jul 10, 2013

I've been having problems merging a spreadsheet with data into an already created table..

The main things in common is the "MC", "First Name", "Last Name".

I'm trying to update dates etc that are on the spreadsheet exported from another database, and update my datebase with those new dates..

View 14 Replies View Related

Tables :: Update Or Merge Data Into Table

Aug 15, 2013

I have an Employee Records table with 29k records that I originally imported from an HRIS system. Lets call this table ORIGINAL table.Each week I export a new Employee Records table from the HRIS system as it contains the latest updated information. IE - New hires, terminations, rate changes, etc. Lets call this table NEW table. It likely contains new records as well as we hire 100+ people per week.

In the ORIGINAL table, I have added fields that are not included in the NEW table. I need to update the records / fields in the ORIGINAL table with the NEW table, but need to keep the ADDED fields.Originally my plan was just to overwrite the ORIGINAL table with the NEW table until I added the additional fields to the ORIGINAL table. I thought that I could export the added fields in the ORIGINAL table, import the NEW table, and run and update query based on the EE ID#.

View 2 Replies View Related

Merge Columns From Many Tables Into One Column In New Table

May 21, 2013

I have 4 tables that store information on guest charges (stayinfo/room rate, fuel charges, bar tab, merch charges) each linked to table carrying guest ID's. Is there a way to combine/merge all the tables into one in such a way that all of the guestID's are in one column, all of the charges are in another column etc? Basically adding one table to the bottom of another.

View 1 Replies View Related

Trying To Import / Merge / Update A Table From Xml File

Feb 23, 2012

I'm trying to import/merge/update a table from an xml file.To import I'm using the following code:

Code:
Private Sub Command0_Click()
Const acAppendData = 2
Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "DATABASE LOCATION"
objAccess.ImportXML "HTTP OF XML FILE", acAppendData
End Sub

This works perfectly to import new records, however what I also need it to do is merge/update the data. So the xml file will contain the correct data and any amendments need to be made to the Access table.

View 4 Replies View Related

Merge Information To New Table From Two Excel Files

Sep 5, 2012

I have linked to excel documents into access. They contain the same header rows but of course with different data.

Example: First name: Last name: Phone number:

How do i merge the information to a new table with the same header rows and the information from the two excel files.

Example new table with: First name: Last name: Phone number:

View 1 Replies View Related

Reports :: Table With Several Entries - Merge Non Blank Records

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

Problem With Make Table Query And Merge To Word Template

May 23, 2005

Hi guys!

I have my word template set up such that some data is copied from the open form into the document and some data is taken from a table which is created from a query based on the content of the form (the record number). This works well HOWEVER (there's always a however isn't there :rolleyes: ) where two users click on the button at exactly the same time or within a very short space of time the query only runs once and either the database crashes (bad) or the document is created for the second person with the wrong data (very bad).

How can I make it so that only one person can run the query at a time (ideally build in a delay in processing so that the query will run for them when the first person has finished...failing that a message to say please try again later)? They will always be working with a different record.

I'm a bit stuck as to what to search for in the forum for an answer to this so haven't really searched.....sorry :(

Many thanks
Jo

View 2 Replies View Related

Creating A List, From A LINK (Join) Table, For Use In Mail Merge

Oct 28, 2005

I am creating a mail-merge application.

The data stored will be dealing with Students and Qualifications that they have attained. The link table in the relationships shown/attached, allows a Student to have multiple qualifications.

When I merge the data, I will need to list all of the qualifications that each student has attained, which will need to be either in a item list, or in a comma-separated list.

The list will need to be pulled from the link table (StudentQualifications). For example:

StudentID #1 >> Qualification #1 Description
StudentID #1 >> Qualification #2 Description
Etc
Etc

So, when the data is merged, it will specify that:

StudentID #1 has acheived Qualification #1 and Qualification #2 and Etc, Etc.

How can I create this list in the first place, which can then be used in the source of the merge for the document.

Any ideas as to how I can pull multiple information into either a single string to pass to the merge or into a list in the document would be appreciated.

Graham

View 2 Replies View Related

Tables :: Auto-populate Table Field From Calculated Field In Another Table?

Jan 15, 2015

I am creating a database to keep up with the expenses for my art business. I have a table for Vendors with a field (Mileage) for one-way mileage that I enter manually (EX: 11.8 miles). Then I have a calculated field that basically just multiplies the Mileage field times two to get total mileage to and from my house to vendor location. (Total Miles) {The reason I want to do this this way right now is because I didn't keep up with my mileage this year and I am having to look up the distance from my home to each location)

Then I have a "supplies" table where I show the date, the vendor, the item, cost, etc, and I want to add a Total Mileage field based on the calculated Total Miles field in the Vendors table that will automatically populate based on the vendor of each transaction. I just can't remember how to make this work and I know just enough SQL to be dangerous.

View 2 Replies View Related

Tables :: Update A Field In One Table Based On Status Of A Field In Another Table

Aug 2, 2013

I have started work on a database to track the many (several hundred per annum) projects my company undertakes. A 'main' table lists projects, their fees, their key dates, their project numbers, etc. I have created another table for tasks. Each task is assigned to a project (via the project number), and may be 'open' or 'closed'. I have separated the tasks table from the projects table as there may be several different tasks for each project. It is also good to keep a record of the tasks.

I want to prepare a report from the projects table that lists projects IF they have any open tasks.

In my mind, this means 'If a task, with the corresponding project number, is open, put a 'Yes' in the 'Tasks open' field of the Projects table.'

View 7 Replies View Related

Update OnHandQty Table Field Based On Qty Field From Another Table / Form

Oct 30, 2012

I have a table called Inventory (table1 - PK=INVID) that contains all inventory ID numbers and descriptions. I have another table called Inventory Transactions (table2 - FK=INVID) that gets updated through a form. When a new transaction is made in table2, I want the transaction amount to get added or subtracted to an OnHandQty field in table1. I tried having table2 (transaction table) as the main form and then table2 as the subform, but I couldn't get table2 to update.

View 5 Replies View Related

Tables :: Auto Populate Field Based On Answer Of Another Field In Same Table

Feb 28, 2013

Within my table if Field 1 has an answer of Self (from drop down), then, I would like Fields 6-12 to auto populate; however, if Field 1 does not have an answer of Self, then leave Fields 6-12 blank.

I am not quite sure how to lay this out. I am using Access 2010.

View 8 Replies View Related

Hotkey For Toggling Between Field Row In Table Design View And Its Field Properties?

Feb 15, 2013

I am making a new Record in the design view of a table (creating a new field in the table), and I am assigning it a date type, is there a hotkey that will select the field properties sheet so that I can select the format of the field without having to move my mouse?

View 1 Replies View Related

Make Field Auto Populate Based On Value Of Field In Another Table

Mar 4, 2008

I'm creating a database that keeps a track of questions and scores.

The questions in the database need to be dynamic and are changed frequently.

I have a scorecard table which keeps a record of scores and the applicable question at the time the record was saved. I need to do this because in 6 months time we may want to provide feedback. As the question may have changed we need to be able to refer back to what the question was.

I want the question field in my scorecard table to populate with the value in my question table.

I have tried a number of things including setting the question field in the scorecard table to a lookup based on the following query:

SELECT tblQ1.Q1
FROM tblQ1;

This works however only as a list or combo box. I don't want the user to have to select the question. I want it to auto populate, is this possible?

View 1 Replies View Related

Send A Content Of Unbound Field In A Form To A Field In The Table

Feb 26, 2006

in my form I created an unbound field with a requested combination, now how can I put those in a table field.
in other words, how can I send the content of a form's unbound field to a field in the table?

your help is very appreciated.

Regards,
CS.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved