concatenate fields into same table...

  • Thread starter Thread starter Kostas Konstantinidis
  • Start date Start date
K

Kostas Konstantinidis

hi all
I am using a table RT_AM_appointment with two fields
date_appoiment and time_appoiment
What I want to do is to concatenate data like e.g.

01/01/08 11:00, 12:00, 18:00
10/01/08 12:00, 13:30, 14:45, 15:30
..... etc

I tried to use a function written by Dev Ashish on
http://www.mvps.org/access/modules/mdl0008.htm
but when I changed
SELECT ContactTitle,
fConcatFld("Customers","ContactTitle","CustomerID","string",[ContactTitle])
AS CustomersFROM CustomersGROUP BY ContactTitle;

with mine as

SELECT date_appoiment , fConcatFld("Customers","date_appoiment
","time_appointmet","string",[date_appoiment ]) AS CustomersFROM
CustomersGROUP BY date_appoiment


it doesn't work even if it works perfect on northiwind.mdb
anybody could help??

many thank's
 
Duane,
it really works
many thank's.

I wish "Merry Christmas and a Happy New Year"
to you and all the people you love them

/kostas


Duane Hookom said:
It may just be a problem related to your issues with spelling field names.
Also, I expect your fields aren't "string".

Consider using the generic concatenate function found at
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=4&SID=zzdd7d864azdc1afzdff5z71b648a94z.
The download contains the function and sample usage.

SELECT date_appoiment , Concatenate("SELECT Time_appointment FROM
Customers
WHERE date_appoiment =#" & date_Appointment & "#")
--
Duane Hookom
Microsoft Access MVP


Kostas Konstantinidis said:
hi all
I am using a table RT_AM_appointment with two fields
date_appoiment and time_appoiment
What I want to do is to concatenate data like e.g.

01/01/08 11:00, 12:00, 18:00
10/01/08 12:00, 13:30, 14:45, 15:30
..... etc

I tried to use a function written by Dev Ashish on
http://www.mvps.org/access/modules/mdl0008.htm
but when I changed
SELECT ContactTitle,
fConcatFld("Customers","ContactTitle","CustomerID","string",[ContactTitle])
AS CustomersFROM CustomersGROUP BY ContactTitle;

with mine as

SELECT date_appoiment , fConcatFld("Customers","date_appoiment
","time_appointmet","string",[date_appoiment ]) AS CustomersFROM
CustomersGROUP BY date_appoiment


it doesn't work even if it works perfect on northiwind.mdb
anybody could help??

many thank's
Click to expand...
Click to expand...
 
Thanks for the holiday wish. The same to you and yours :-)

--
Duane Hookom
Microsoft Access MVP


Kostas Konstantinidis said:
Duane,
it really works
many thank's.

I wish "Merry Christmas and a Happy New Year"
to you and all the people you love them

/kostas


Duane Hookom said:
It may just be a problem related to your issues with spelling field names.
Also, I expect your fields aren't "string".

Consider using the generic concatenate function found at
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=4&SID=zzdd7d864azdc1afzdff5z71b648a94z.
The download contains the function and sample usage.

SELECT date_appoiment , Concatenate("SELECT Time_appointment FROM
Customers
WHERE date_appoiment =#" & date_Appointment & "#")
--
Duane Hookom
Microsoft Access MVP


Kostas Konstantinidis said:
hi all
I am using a table RT_AM_appointment with two fields
date_appoiment and time_appoiment
What I want to do is to concatenate data like e.g.

01/01/08 11:00, 12:00, 18:00
10/01/08 12:00, 13:30, 14:45, 15:30
..... etc

I tried to use a function written by Dev Ashish on
http://www.mvps.org/access/modules/mdl0008.htm
but when I changed
SELECT ContactTitle,
fConcatFld("Customers","ContactTitle","CustomerID","string",[ContactTitle])
AS CustomersFROM CustomersGROUP BY ContactTitle;

with mine as

SELECT date_appoiment , fConcatFld("Customers","date_appoiment
","time_appointmet","string",[date_appoiment ]) AS CustomersFROM
CustomersGROUP BY date_appoiment


it doesn't work even if it works perfect on northiwind.mdb
anybody could help??

many thank's
Click to expand...
Click to expand...
Click to expand...
 
Back
Top