Duane: Generic concatenate function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

niuginikiwi - 17 Jan 2007 23:40 GMT

I have dowloaded and imported the generic concatenate function into my
application from
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
I have a report that I filter by date range and customer name and get
several deliveries that were made based on the criteria. Each delivery may
or may not have a description txt field in the tblDelivery which is attached
to the main report.

on the report footer I have field called showAll that I have put
=Concatenate("SELECT DeliveryDescription FROM tblDelivery WHERE DeliveryID
=" & [DeliveryID]) as the recordsource but nothing gets displayed when i run
the report.
But when I move this field to the page footer section, it only shows what
entry is on the first Delivery that gets printed.

How do I get this to work. ie to go throw all deliveries that meets the
criteria and then get any descriptions that exist and print them out on the
showAll textfield on the report footer?

Thanks

Signature

niuginikiwi
Nelson, New Zealand

Reply to this Message

Duane Hookom - 18 Jan 2007 02:13 GMT

I expect DeliveryID is the primary key in tblDelivery. If this is the case,
the function would only return at the most one description. I assume you want
to return results from more than one record in tblDelivery.

You really need to provide some information about your table structure if
you want help with function.

Signature

Duane Hookom
Microsoft Access MVP

> I have dowloaded and imported the generic concatenate function into my
> application from
[quoted text clipped - 16 lines]
>
> Thanks

Reply to this Message