Combine fields from different rows into one field
I want to take the comment fields from each customer and combine them (in a new table) into one field. So the new table will have one row per customer with their comments combined into one field.
So we start with table one:
x | Good
x | Bad
x | Ugly
y | Morning
y | Noon
y | Night
And we then make table two:
x | Good Bad Ugly
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Currently I have six different reports each based on a different query. What I have done for each of the reports is created a header group and put the field I want to count into the header group plus a =Count("*") control text box. This gets me the data but only for one field. I then export each report to an excel file and combine the results from all six. Is there a way to combine this into one query to populate one report?
The 1st field is TD1 and the 2nd is TD2.
I've tried all type of combinations but none of them work except for the following:
=[TD1] + [TD2]
The contents of these fields are 10 and 20 respectively.
BUT, it creates 1020 and I'd like the results to be 30 (add them together) instead.
I've looked all over the place but can't find anything that addresses this.
I also tried to do this within the query by adding a new field TD1TD2 but I also couldn't figure out how to get that to work
For each selection of rows there will be a different amount of rows. How do I create a query that selects the rows that will create the answer I am looking for.
How shall I enter the selection criteria for the first and the last row to get all rows in between?
For most rows in the report the height property for the six fields are the same, based on the fact that the data value in the fields does not force the field to grow.
However in some cases the description field can have up to 200 characters and will force the field to be higher than the other five fields in the same row (refer to attached screen shot).
I was wondering if there is a way that I can tell the fields to grow to the same height as the tallest field.
I am trying to combine a cell from different rows in the table.
I have attached a simplified example with two columns. The left column contains labels and the right column contains text boxes. In this example, there are three blank rows. I would like toprevent these blank rows from displaying, and I would like the first three fields from the next record (not shown) to replace the blank rows.
In the Details Section and in text box properties, I have the Can Grow and Can Shrink properties set to Yes. I have tried a variety of solutions but nothing has worked (probably because I am not correctly applying the solutions!).