Showing all data from a field in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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!


Duane Hookom said:
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


AT said:
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.
Click to expand...
Click to expand...
 
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!!

AT said:
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!


Duane Hookom said:
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


AT said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top