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.
Also side note, When I combine two spreadsheets in a query, will the database understand to put a N/A or whatever in the value if one spreadsheet has an extra field name
Basically, there is an ID field (column 1) that I've already put in place and then I have two fields of values to choose from (Field A and Field B) so that I will end up with two columns in total. If Field A = 0, I'd like the query to take the value from Field B and multiply it by -1 and have that be the value in column 2. If there is already a value besides 0 in Field A, I'd like the query to take that value.
Also, if the ID field is blank or is labeled 'Excluded,' I'd like the query to leave those rows out.
So for example if the field were to display "New York NY, 10011" and I wanted to change it to "Manhattan NY, 10012" I could just type it into the field and it would update the apropriate fields.
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?
The first field is a text field that contains an acronym representing a company, e.g., USPS. This value will be selected from a Combo Box.
The second field contains a date (Short Date format, 10/11/2010), which will not necessary be the current date.
I want to change the Date field into a yyyymmdd format, insert a period at the end, and then append the acronym field so I'll end up with something that looks like this:
The ultimate goal is for this to run as an On Exit Event Procedure after I enter the date and move on to the next field on my form.