Showing all data from a field in a table

[AT]

Sorry for the re-post, but I just can't seem to get this to work. This is
the SQL for my query:
SELECT [tblBarge Information].BargeID, fConcatChild("tblBay
Information","BargeID","Bay #","Long",[BargeID]) AS SubFormValues
FROM [tblBarge Information];

With the tblBarge Information being the 1 and the tblBay Information being
the M. The BargeID is the auto# and the Bay # is the data I am looking for.
The fConcatChild being code that I got from the last post.

But when I run my query the SubFormValues field is blank. Any ideas?

Let me know if you need more details.

Thanks in advance.

 

[Duane Hookom]

You might want to try the generic concatenate function available at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. There
are several sample usages.

 

[AT]

Thanks Duane for your suggestion, that's been very helpful. That site is
actually where I found the fConcatChild module I have in my code. I am using
that module in the SQL statement for my query, but I must just be missing
something, because I do not get any data in the Bay # field. Any additional
suggestions you could give, I would appreciate.

Thanks!

You might want to try the generic concatenate function available at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. There
are several sample usages.

--
Duane Hookom
MS Access MVP

Sorry for the re-post, but I just can't seem to get this to work. This is
the SQL for my query:
SELECT [tblBarge Information].BargeID, fConcatChild("tblBay
Information","BargeID","Bay #","Long",[BargeID]) AS SubFormValues
FROM [tblBarge Information];

With the tblBarge Information being the 1 and the tblBay Information being
the M. The BargeID is the auto# and the Bay # is the data I am looking for.
The fConcatChild being code that I got from the last post.

But when I run my query the SubFormValues field is blank. Any ideas?

Let me know if you need more details.

Thanks in advance.

 

[AT]

I apoligize, I thought the site you gave me was the same as last time. When
I went back to double check my code I realized it was a different site. And
I now have it working perfectly. Thanks so much for your help!!

Thanks Duane for your suggestion, that's been very helpful. That site is
actually where I found the fConcatChild module I have in my code. I am using
that module in the SQL statement for my query, but I must just be missing
something, because I do not get any data in the Bay # field. Any additional
suggestions you could give, I would appreciate.

Thanks!

You might want to try the generic concatenate function available at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. There
are several sample usages.

--
Duane Hookom
MS Access MVP

Sorry for the re-post, but I just can't seem to get this to work. This is
the SQL for my query:
SELECT [tblBarge Information].BargeID, fConcatChild("tblBay
Information","BargeID","Bay #","Long",[BargeID]) AS SubFormValues
FROM [tblBarge Information];

With the tblBarge Information being the 1 and the tblBay Information being
the M. The BargeID is the auto# and the Bay # is the data I am looking for.
The fConcatChild being code that I got from the last post.

But when I run my query the SubFormValues field is blank. Any ideas?

Let me know if you need more details.

Thanks in advance.