Topics Search

Combine fields from different rows into one field

Combine fields from different rows into one field
Views: 35
I have a table that has a 2 fields Customer & Comment. Each customer could have multiple entries (rows) in this table.

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:

Cust.
x | Good
x | Bad
x | Ugly
y | Morning
y | Noon
y | Night

And we then make table two:

Cust.
x | Good Bad Ugly
y |
Sponsored Links:

Similar posts...

 

Combine same IDs in report but with Different Values

Combine same IDs in report but with Different Values Icon
Is it possible to combine rows with same channel ID's but with different values? for ex: in pic, you see the ID B0175 with 11 rows. but retain thevalues from all eleven rows and put them in one line? so it would display a "1" in whatever month it belongs to
 

Concatenate multiple rows

Concatenate multiple rows Icon
Is there a good way to concatenate data from multiple rows into one field? I have several rows with different dates and I need to combine the comment text for each of the dates into one field and group it as one record. How can I do that?
 

Combine Reports

Combine Reports Icon
I have a table that consists of 10 fields. Six of the fields are populated from a drop down list. Some of the lists have as many as 12 choices to choose from and some, as little as 5. I want to create a report that will show me the number of time each one of the possible choices in that particular field has been chosen. All six fields are text.

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?
 

form formula to combine two fields

form formula to combine two fields Icon
I've been trying (with no luck) to combine two fields in a form.

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
 

dlookup in access

dlookup in access Icon
I have a table from which I want to select an inteval of rows. I then want to summarize one field from the selected rows. The selection criteria can identify each of the rows.

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?
 

Introduction to Expressions and Operations

Introduction to Expressions and Operations Icon
The data fields we have used so far were created in tables and then made available to other objects (forms and reports), so those objects can implement their own functionality without worrying about displaying empty or insignificant fields. In various scenarios, you will need to display a field that is a combination of other fields. For example, you may need to combine a first name to a last name fields in order to create a full name field, or, to calculate an employees weekly salary, you may need to retrieve the value of a Salary field and multiply it with the value of a total number of hours worked in a week.
 

Auto Adjusting Field Height

Auto Adjusting Field Height Icon
I have a report that is used to generate maintenance lists and to act as a checklist list for our fleet section. Each row on the report contains detail from six fields provided to the report from a query.

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.
 

Access 2013: Creating Calculated Fields and Totals Rows

Access 2013: Creating Calculated Fields and Totals Rows Icon
Calculated fields and totals rows let you perform calculations with the data in your tables. Calculated fields perform calculations using data within one record, while totals rows perform a calculation on an entire field of data.
 

combining rows..

combining rows.. Icon
I've tried several things I have found around the net, including here. I'm assuming (based on the other code I have tried) this will have to be VBA?

I am trying to combine a cell from different rows in the table.
 

Hide Fields With Null Values

Hide Fields With Null Values Icon
I need to prevent blank rows from displaying in a report. The blank rows represent fields with null values, which appear in almost every record.

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!).