Field Combination

[CosmaL]

Hello my friends!


I need your valuable help once more!


I'm trying to create a report which will contain only 2 fields:

-ID (will be the same for all records)

-Description (which will be different for each record).


Maximum records will be 5.


My question is, if there's a way to show in the report, the fields continuously in a raw (description. description. description. etc) instead of a record/raw.


Thank you in advance!!!!!!!


Best Regards,
Costas

 

[Minty]

I'm not sure how you would get the data stored like you describe but you need a concatenation method.

This one http://allenbrowne.com/func-concat.html is considered the standard.

 

[isladogs]

If I understand you correctly, you can hide repeated values for one (or more) fields. Click the field then look in the property sheet

 

[jdraw]

@CosmaL,

I suggest that you restate your question to remove some confusion.
This statement is confusing 9( to me at least)

-ID (will be the same for all records)

Perhaps you could create a mockup of what you want as output.

 

[CosmaL]

@jdraw
Report (subreport actually) will collect data under the same ID from the main form. Main form will have the Record ID and ID which is the same for the subform's data.



Guys,
I think it's better to leave it record by raw...

 

[Mark_]

@ Cosmal,

What it sounds like you really want to do is format a text box on the parent with the contents of child records.

To do so, you would declare a string, loop through child records appending their [Description] to the string, then filling the text box with the contents of your string.

You would do this when you format the detail for each parent record.

Personally I'd make a function that accepts the parent ID as a parameter that returns your formatted string.

Let me know if this is getting close to what you want to have happen.

 

[CosmaL]

@Mark


thanks!


I've tried it and the result wasn't good enough.


I kept it as a subreport.


Thank you all!