Consolidate Multiple Names

Jun 11, 2013

Each month I get the previous months data. In that data, I have a list of names that have duplicates in them. Some of the names have last, first middle. Some have just last, first. I want to combine the like names and leave the unlike names not combined.I want to combine in this situation

ex. Smith, Peter
Smith, Peter W

I do not want to combine in this situation
ex. Smith, Peter M
Smith, Peter W

My goal is to get the original name in a table with the combined name next to it.

Original Name
New Name

Smith, Peter
Smith, Peter

Smith, Peter W
Smith, Peter

View Replies


ADVERTISEMENT

Queries :: Duplicates In Data - Consolidate Multiple Names

Jun 11, 2013

Each month I get the previous months data. In that data, I have a list of names that have duplicates in them. Some of the names have last, first middle. Some have just last, first. I want to combine the like names and leave the unlike names not combined.

I want to combine in this situation
ex. Smith, Peter
Smith, Peter W

I do not want to combine in this situation
ex. Smith, Peter M
Smith, Peter W

My goal is to get the original name in a table with the combined name next to it.

Original NameNew Name
Smith, PeterSmith, Peter
Smith, Peter WSmith, Peter

View 2 Replies View Related

Queries :: How To Consolidate Multiple Variances Using A Query

Aug 29, 2013

I have 3 tables of data, where I want to cross reference information to produce exception reports.

The tables all have Employee number held within them, and these form the basis of my queries.

We want to be able to cross reference locally held staffing information with centrally held HR and payroll records.

The type of information we want to be able to check, is if the hours of the individual are the same in all 3 records, the grade they are being paid for, the cost centre, and that the names match.

Currently we run separate queries for all of these, and I want to be able to consolidate the exceptions in one report, to save looking at the same persons record more than once.

For example, if John Smith has a different name, grade and cost centre are all different - we may be accessing his record 6 times, once for each variance against payroll and HR records.

Is there a way that I can pull all this information together to speed up the reconciliation process?

View 1 Replies View Related

Modules & VBA :: Consolidate Tables From Multiple Databases Into One Database

Jan 21, 2014

I have one Master database and multiple child databases in a folder. Each of these databases (both Parent and Child) have identical table called "source". I need a VBA code which will consolidate tables of child database into the Parent database table.

View 8 Replies View Related

Queries :: Consolidate Multiple Columns Into Two Columns

May 14, 2014

I have a MS ACCESS 2010 database with a data table which i am trying to create a query from. I have 6 columns of data( one with an ID Field and 5 Name Fields). Below i have made examples of how it first appears as a simple query and the second will show you what i would like it to look like.

What the simple query looks like: [URL] ...

Second what I want the query to look like: [URL] ....

View 2 Replies View Related

Can Add Multiple Names To One ID (Auto-number)

Mar 25, 2014

I work in University accommodation housing 3000 students and we conduct meetings with the residents when they are to be disciplined.. for various things such as smoking in their room, poor conduct, or cause they've broken a window decided playing football in the kitchen using a window as a goal.

They can then be given a fine or community service or a warning.

I've created a database that logs a these meetings and it works fine when one person is called in, it logs the individual (Name, ID Number, Accommodation, Flat & Room No) and I can transfer the details to a new community service record or fine record and it all links to the auto generate ID number (known as the Case Number).

Though in cases where there is more than one person involved and each are given their own "discipline" I haven't got the knowledge to know how to keep it linked to the same 'Case Number'.

Can I create a case, add more than one person to the meeting record who will be present?

Then following that meeting for example Alan gets 10 hours community service, John gets a £40 fine, and Dave gets a £40 fine and 5 hours community service? Though all 3 are still linked to the same case number from the initial meeting?

View 5 Replies View Related

General :: Names In Multiple Horizontal Columns

Dec 18, 2013

I have a database with employee folders containing various bits of information. My intent is to have a main page with a sub report or from containing employee names. Instead of the names being displayed in a single vertical column with a scroll bar, I would like to display multiple columns of say twelve names each with a horizontal scroll bar no information with be edited from the "main" page..

The information would be "last name, first name" from a query, you would select (highlight) the name and hit a button to bring up a different form with that employees information or double click for the same results.

View 6 Replies View Related

Tables :: Multiple Name IDs Link To Same Names Table

Jul 30, 2013

I have a risk table containing risks and risk owners (many owners for one risk), meaning that I have two risk owners columns. What I would like to do is to connect both risk owner columns (containing the name IDs) to the Names table. But Access does not allow to connect more than 1 column to another.

See the attached file...

View 6 Replies View Related

Forms :: Search Combo Box With Multiple Last Names

Jan 19, 2014

I have a combo box that brings up records for an individual. I have people with the same last names and have their first names showing on the combo box list, but when i choose one of them, it will always go to the name of the person who was entered first, so matter who i pick(that has the same last name).

View 1 Replies View Related

Assign Multiple Names To Single Record

Jul 18, 2013

I have a Project Database where I keep track of projects throughout my plant. A project can have one owner or several owners working on it. Is there a way to assign multiple owners to a project?

I tried doing a subform but I don't like how it looks on the form and when I try to do a query that filters based on a person's name, the form has to be a single form rather than a continuous form which is not what I want.

Is there another way that I can accomplish this?

View 1 Replies View Related

Combine Multiple Tables (all Are With Unique ID Names) Into One Table?

Nov 22, 2013

I have create 6 tables for library books (which are differentiated by categories). Each table has different category and unique ID name e.g. F1, F2, F3..(for table 1), G1, G2, G3..(for table 2) and so on. How do I combine all those tables into 1 table for easy search for a book rather than open up each table? Tried append query but its ID run as 1, 2, 3... , not F1, F2, F3 and it only append 1 table, not the rest.

View 3 Replies View Related

Can Place Multiple Field Names To A Single Index?

Aug 5, 2012

Add and Index named Location to the tblGuest table that consists of the StateProv and City fields and uses the default property settings, Delete the PostalCode Index, save then close the table.

I have looked up all info in the text reffering to Indexing and cant seem to come to a conclusion of the way to complete the underlined area area. For the class they provide you with the files and in this particular file the primekey is Guest ID with a field value of GuestID. There are two other Indexes PostalCode with field value PostalCode and GuestID with field value of GuestID.

View 2 Replies View Related

Query Searching Multiple Tables' Field Names (not Values)

Jan 22, 2007

Hi. Please do not lecture me on database normalization, as this truly is not in my control.

I have 2 dozen tables, each with 13 fields. All of the field names exist in at least 12 of the tables. And all tables share a ssn field where values are common.(Confused yet? Sorry, if you are...)

If I design a query showing all 2 dozen tables and their fields...
Can I set up a query criteria where I enter the requested ssn and then the required field name and have the result show the values of all the fields with that name, among the ones of the 2 dozen tables where that field name exists? (for that specified ssn)

If I am only as clear as mud, please let me know, and I will try again.
Or, by asking if I can search for field values querying by field name, am I any clearer?

Russ

View 14 Replies View Related

Forms :: Multiple Instances Where Inactive Names Should Not Show On List

Mar 22, 2013

We have a form that will have one combo box for Associates (like Employee in the OPs DB) which I've got set to show only active Associates for new entry per the tips in the above thread, but we'll also have a combo box for Developer which I need to function the same way. I don't know how to add that part to the On Current event?

Code:
Private Sub Form_Current()
Dim strComboRowSource As String
If Me.NewRecord Then
strComboRowSource = "SELECT T_Associates.AssociateID, T_Associates.Associate, T_Associates.Active " & _
"FROM T_Associates " & _
"WHERE (((T_Associates.Active)=True));"

[Code] .....

View 4 Replies View Related

Forms :: Add Multiple Checkbox Names Into Single Table Field

Aug 15, 2013

Im constructing a form with check boxes next to names. Id like to have the checked names input serially into a single table field like:

IssuedTo
Name1, Name2, Name3

There are 8 possible Names. Is there way to do this without a long complicated If-Else-Then function?

View 5 Replies View Related

Tables :: Modifying Table Structure - How To Provide Multiple Names At One Address

Jan 8, 2013

I need to modify my customer table to cater for multiple names at one address.

Should I move all the addresses into their own separate table or leave them as is (name-Address-postcode- email etc in one table) and put the additional addressees into a separate table or is there a better way I have not thought of.

View 6 Replies View Related

Consolidate 3 Queries Down To 1, Possible In My Situation?

Dec 26, 2006

In order to find the most recent piece of data for a particular customer I need to query my table in 3 iterations.

I have a TABLE with data in it pertaining to all customers.

QUERY 1 orders all the records in TABLE by date.

QUERY 2 plucks all records related to specified customer from QUERY 1.

QUERY 3 selects the TOP 1 from QUERY 2.

My main concern is that this all happens automatically. Can I shorten this process at all?

View 4 Replies View Related

Trying To Consolidate Information With Different Value Types

Jul 10, 2013

I have a database that, vaguely looks like the following

NAME Value Category A Value Category B Value Category C

Name A -50 0 0
Name A 0 50 0
Name B -100 0 0
Name B 0 75 10
Name B -25 0 0
Name C -100 0 0

Etc. etc.

What I'd like is to find a query that will first, generate a Category D which should be a total of all the values in the three different categories and consolidates the names to one line. So it should spit something like this out.

NAME Value Category A Value Category B Value Category C Total
Name A -50 50 0 0
Name B -125 75 10 -40
Name C -100 0 0 -100

After this, I'd like to have another query that will only display the values that are NOT zero.

NAME Val Cat A Val Cat B Val Cat C Total
Name B -125 75 10 -40
Name C -100 0 0 -100

View 3 Replies View Related

Ways To Select And Consolidate Records

Nov 24, 2004

I am currently building a db that will handle information on many events around the world. What I would like to do is set a check box that when people scroll through the different records they could check it and it (the current record they are viewing) will go into a compiled list wherein the iindividual record details of that list which the user created by their choices could be exported to an excell sheet (to automate a reporting need in the job) I have seen functions like this in large websites particularly the classified job sections in the seattle Times . where as you scroll through you see something you like you mark it continue scrolling mark another and then when you are all done you go to a page that has all and only your selections.

Can anyone tell me where to start on this one what am I Looking for Etc.
This will be the next big step in this my first database.
All help greatly appreciated

View 1 Replies View Related

Modules & VBA :: Consolidate Addresses By Similarities?

Apr 9, 2015

I need to consolidate mailing addresses so that many records are grouped to one invoice based on the address they fall under. I am currently using an update query to change addresses that are similar to match exactly. Is there a way to make it so the addresses group together based on similarities rather than exact matches? For example I have two addresses:

1301 W Johnson Street Phoenix, Arizona 85725
1301 West Johnson St Phoenix, AZ 85725-7201

These are the same property however without cleaning them up manually to match, two invoices will be printed. Is there a way to consolidate these?

View 2 Replies View Related

Forms :: Form To Consolidate Duplicate Customers?

Apr 10, 2014

I have a few duplicate customer queries (different duplicate fields etc). I would like to construct a form to make it easy for an end user to remove the duplicates.

The main problems are...

1. the newer customer is to be deleted

2. any/all orders from the newer customer will be moved to the older customer before deletion.

3. preferably an easy way to switch between the duplicate queries in the same form, though if this is a problem I could just have one small dialog box/form, linking to 3 different duplicate query/forms.

I think other changes between the customers will be easy enough to just do in the subform, i.e update email address/tel/status/salesperson etc. These can just be edited directly?

But the transferring of orders can't be edited directly because there may be several orders and could be errors etc.

tblCustomers [CustomerNumber] primary key
tblCustomerOrders [OrderNumber] primary key
[CustomerNumber] linking to tblCustomers

So all that needs to be updated is [CustomerNumber] in tblCustomerOrders. All orders for the newer customer to have the CustomerNumber field updated to match the older customer. Then the newer customer is deleted.

I would just have a button with a message box to run the code, update CustomerNumber/s and delete record.

View 2 Replies View Related

Tables :: Consolidate Into Fixed Number Of Rows - Many Columns

Oct 15, 2014

I have a table ("Student Info") that looks like this:

ID....Student.....Student #......Teacher Name......Teacher ID
1........A...............432...............Alice.. .................62
2........B...............674...............Alice.. .................62
3........C...............875...............Alice.. .................62
4........D...............934...............Katie.. ................18
5........E...............345...............Katie.. ................18
6........F...............134...............Dan.... .................4
7........G...............734...............Dan.... .................4

The above table suits me well for data entry.For analysis reasons, I want it to have another table or query or something (let's call it "Teacher Info") that looks like this:

Teacher ID....Teacher Name....St1.....St2......St3...St#1...St#2...St#3
62......................Alice...........A......... B........C.....432.....674.....875
18......................Katie...........D......... E........-.....934.....345......-
4........................Dan............F......... G........-.....134.....734......-

Is there any way that I could do this? I have been struggling with this for a while.Just so you know how this data is connected - At the moment, I have a form where I put in new Teacher information. I have a subform attached to that, where I put the student names and numbers. This way, the students are linked with their student #s, and each of them are linked to a teacher. Unfortunately, the table ("New Teacher Registration") that this creates looks like this:

id....Teacher Name
62...... Alice
(+ tab).........A.........432
...................B.........674
...................C.........875
18.......Katie
(+ tab).........D.........934
...................E.........345
4........Dan
(+ tab).........F.........134
...................G.........734

I created the "Student Info" table (above) from this to work with data entry (drop-downs and such). Now I'd like to create a "Teacher Info" table (above) for analysis.

View 11 Replies View Related

Modules & VBA :: Code To Consolidate Two Tables And Remove Duplicate Entries

Oct 3, 2013

I have two tables in my Access database. Table 1 has three columns, First Name, Last Name and Phone Number. Table 2 has just 2 columns, First Name and Last Name. What I would like to do is write a VBA macro to consolidate Table 2 into Table 1 and insure any duplicate First Name-Last Name combination is removed.

Table1

Code:
F.Name L.Name Tel.N.
John Smith 12345
Larry Miller 12344
Tony Woods 12333

Table2

Code:
F.Name L.Name
Albert Black
Larry Miller
John Bush

Table1 Post-Macro

Code:
F.Name L.Name Tel.N.
John Smith 12345
Larry Miller 12344
Tony Woods 12333
Albert Black
John Bush

View 1 Replies View Related

Field Names Don't Match Names On Form

Nov 7, 2006

I have a form with several data fields on it. I also have a button on the form that allows the user to duplicate a record . The reason for this duplication is so that if there will be an additional client record for the same customer, but only one piece of data will need to be changed, it's easier to copy the record and then change the one field.

However, I am getting the following message:

"some of the field names you tried to paste don't match fieldnames on the form"

and then not all data in all fields gets duplicated.

I need to figure this out, but am going nuts with it. If anyone has an idea or two they'd care to toss my way, I would be happy.

Thanks one more time, in advance!!

View 1 Replies View Related

Reports :: Repeating Row Names And Column Names

Jan 17, 2014

How can I repeat column names and row names on multiple pages of the report ?

View 1 Replies View Related

Names

Apr 19, 2005

I have a feild that requires firstname and lasatname for input.

How do I set it up so that is will takie the first name and Capitialize the first letter and do the same for the last name.

Ex: enter: john smith

needs to be: John Smith

Same thing for Company name

ex: the best company
need: The Best Company

I need it this way for a mail merge document I need to use

View 4 Replies View Related







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