G
Guest
I have successfully accomplished combining data from 2 fields in a query into a single field in the same query. I cannot seem to do the same with a table. Seems like it should be easy. Can anyone help?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niklas Östergren
A query is only a view of the data in a table! Unless you don´t add data
into a table or delete or create a table.
There is at least 2 ways to do this in. And I only know how to explain one
of them (sorry).
Create a tablequery (where you creat a new table with the conatenated data
in one field and the primary key in the second field (you need some field to
identifye which data goes to which record in your original table.
Then create a field in you original table to hold the conatenated data. And
last create a new query which add the data to your original table. This is
one way to go, not the best way I asume but it works!
Now to my Q: Why do you need to do this if you can do it whenever needed?
What I´m after here is normalization so if you already have the data you
need you can always conatenate the data whenever you feel like. You don´t
have to store it, or?
// Niklas
table. Seems like it should be easy. Can anyone help?
into a table or delete or create a table.
There is at least 2 ways to do this in. And I only know how to explain one
of them (sorry).
Create a tablequery (where you creat a new table with the conatenated data
in one field and the primary key in the second field (you need some field to
identifye which data goes to which record in your original table.
Then create a field in you original table to hold the conatenated data. And
last create a new query which add the data to your original table. This is
one way to go, not the best way I asume but it works!
Now to my Q: Why do you need to do this if you can do it whenever needed?
What I´m after here is normalization so if you already have the data you
need you can always conatenate the data whenever you feel like. You don´t
have to store it, or?
// Niklas
into a single field in the same query. I cannot seem to do the same with aDWS said:I have successfully accomplished combining data from 2 fields in a query
table. Seems like it should be easy. Can anyone help?
D
DWS
The end users of the data in this table have little or no
experience with MS Access. The forementioned concatenated
field is a primary key and unique identifier with much
related data. Im trying to make it as easy as I can for
them. thanks for your help. DWS
experience with MS Access. The forementioned concatenated
field is a primary key and unique identifier with much
related data. Im trying to make it as easy as I can for
them. thanks for your help. DWS
L
Lynn Trapp
DWS,
Attempting to concatenate data from 2 fields into one and referring to it as
a primary key, will NOT make things easier for your end users, even if it
were possible to do. You can have multiple fields serve as the primary key
and unique identifier of your table and then concatenate them on the fly for
display purposes.
--
Lynn Trapp
MS Access MVP
(e-mail address removed)
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
The end users of the data in this table have little or no
experience with MS Access. The forementioned concatenated
field is a primary key and unique identifier with much
related data. Im trying to make it as easy as I can for
them. thanks for your help. DWS
Attempting to concatenate data from 2 fields into one and referring to it as
a primary key, will NOT make things easier for your end users, even if it
were possible to do. You can have multiple fields serve as the primary key
and unique identifier of your table and then concatenate them on the fly for
display purposes.
--
Lynn Trapp
MS Access MVP
(e-mail address removed)
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
The end users of the data in this table have little or no
experience with MS Access. The forementioned concatenated
field is a primary key and unique identifier with much
related data. Im trying to make it as easy as I can for
them. thanks for your help. DWS