Combine multiple records in a table into one field in another table based on fields in a third table



Category : Databases

I have three tables:


Table 1:
pid, name, address
1 Dale BLANK
Table 2:
pid, moid
1 12
Table 3:
moid, address
12 123 Main
12 12 South
12 99 North

For output I need:


Table 1:
pid, name, address
1 Dawn 123 Mian,12 South,99 North

How can i combine multiple addresses in table 3 into one address field in table 1 linking the two tables with information in table 2?


View Replies

Related to : Combine multiple records in a table into one field in another table based on fields in a third table


Access97...append records from table of varying fields into single-field table
Category : VB & VBnet
Hi all,
New to this forum, and pretty much a complete noob with VB, but I've done a few things with it in Access so I'm not tatally lost. Here's my situation: my users take in a rather large and ugly Word document from a client (essentially a print-out from a mainframe application) which contain

View Replies


Qry header table records based on form table field without duplicates
Category : Access
This sql statement is returning the results that I want, but it is returning each record multiple times based on how many records there are in the subTable. How can i set this up so it only returns only one instance of each record?
View Replies


Auto update fields from one table based on a field in another table
Category : Access
I have created a data entrey form where user would enter the employee id and I would like to automatically update empoyee name, salary on this table from the employees table. I have spent so much time and can't go any far. I am very new to VB.
thanks

View Replies


Linking Field in Table to Different Table based on a fields value
Category : Excel
Using Access 2007 --
Ok, this is my problem.
I have 2 Tables;
1) Orders
2) Data for Orders
Table 1) consisist of an Order # (Primary Key), which is linked to Order # on Table 2
Table 1) has the basics for the order, price, who placed it, and so on.
Table 2) has the

View Replies


Insert into a table fields from another table based on a field
Category : Development
Hi All
I have 2 tables (as shown below), if i add a row to the FILES TABLE then the myid value is added to mydata list in the PLAYLISTS TABLE, based on the genre matching the myname values.
Hope this makes sense.
So my question is how do i add myid to mydata when new files are added t

View Replies


Updating multiple records for one table based on a condition of a column within that table that is unknown
Category : Databases

I am attempting to update multiple columns to an unknown id that is system generated. The way to find this unknown value is to search by a unique identifier that I have manually added to the DB.


The purpose is to link a child record to a parent record.


in the below the


View Replies


multiple fields in 1 table joined to 1 field in a 2nd table
Category : Access
I have not run into this before, and hope there is a solution out there.
Table1 contains 6 fields - fail1, fail2,....fail6
Table2 contains 2 fields - Code, Description
I want my query to JOIN on fail1, fail2..... to CODE and have the 6 different descriptions show in my query o

View Replies


Relating One Field in a Table to Multiple Fields in another Table
Category : Development
MS Access 97
Beginner/Moderate Level User
I am trying to create a Database to track Workouts in MS Access 97.
I have one Table named Workouts that contains the following Fields: Workout Code (e.g: U100), WorkoutActivity (e.g.: Bench Press: Flat Bench Straightbar) (note: this

View Replies


Creating multiple records in table A based on table B?
Category : Access
Hey all-
I'm doing a project for a high school and was wondering if there was some way to create multiple records in table A based on table B.
If some one could please help. Thanx a lot.

View Replies


Combining multiple records into one based on a key field -- inside one table !
Category : Development
Im really scratching my head over this one. Im working with CSV data exported
from Excel, which explains why its a mess to begin with.
Within a table (or via any other means someone might be able to recommend) I
need to combine multiple records which share two like fields. (If thats

View Replies


2012 / 2017 Copyrights BigHow , All Rights Reserved .