concatenate fields into same table...

[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 Hookom]

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 & "#")

 

[Kostas Konstantinidis]

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

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

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 Hookom]

Thanks for the holiday wish. The same to you and yours

--
Duane Hookom
Microsoft Access MVP

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

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

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