G
Guest
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
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