God like people please advise

[DaaAgent]

How do I put the same field name [SuppliersName] from multiple records into a single text box for a report!

eg HolidayExtrasInsurance / BritishAirways / VIP Airport Lounges / RoyalCaribbean

We have a wee MS2000 DB that holds
Table 1 tbl_Enquiry (ENQID)
Master table that contains fields for contact details & names etc

Table 2 tbl_Enquiry_Actions (ENQACTQID)
Linked to table 1
Contains multiple records of travelling components of the booking
Fields examples SuppliersName, SupplierCost, Propertyname, DateOfDeparture etc

On 1 of the reports I have to display a summary of the SuppliersNames per (ENQID)

And the real icing on the cake would be to putt the suppliers in date of departure order

Thank you in advance for the help in this matter

 

[Pat Hartman]

This article in the KB should get you started.

http://support.microsoft.com/default.aspx?scid=kb;en-us;141624

 

[DaaAgent]

Thanks for the link Pat "Concatenate" thats the word i was looking for