Hi all!

I'd to create a calculated column that holds the first field of 4

custom type columns.

This is the example:

I've got 4 custom type columns of type "Address". These types have 3

fields: City, Street and Number.

Now, I want another column called "Locations" that will have the

concatenation of the 4 cities.

Example:

Address1: Chicago, Street1, 111

Address2: Madrid, Street2, 222

Address3: New York, Street3, 333

Address4: Los Angeles, Street4, 444

Locations: Chicago, Madrid, New York, Los Angeles.

Thanks.

1. "Matching" column A's values in column B

2. Counting A's in a table column 1, F's in column 2, etc...

Hi,

I have a database where you can type in students' responses to

questions on a test.

I was able to create a count on a query that shows me how many

people selected the answer A (the correct answer) to question 1, F to

question 2, etc... I would like to have my query show the responses

for all of the questions that way I don't have to open

up 25 different queries to get a sense of how many students got each

question right.

When I just do a query with a count for question 1, the function works

accordingly telling me I have 10 A's, 2 C's, etc... However, when I

add more columns to show question 2 it

still ultimately shows me how many A's were selected for the first

question, but it does not put all the A's together as the table below

shows. Instead, it has three categories for A, 2 for D, etc... (the

numbers do add up correctly though). I'm not sure why it is doing

that. Any ideas?? I've included the SQL code below the table.

SA1 CountOfA SA2 CountOfF

10 10

A 8 F 8

A 1 H 1

A 1 J 1

C 1 F 1

D 1 F 1

D 2 G 2

E 1 F 1

Here is the SQL code that is producing this table.

SELECT Table1.SA1, Count(Table1.A) AS CountOfA, Table1.[SA2],

Count(Table1.F) AS CountOfF

FROM Table1

GROUP BY Table1.SA1, Table1.A, Table1.SA2, Table1.F;

much appreciative,

Paula

3. select range in column, calculate on range plus 3 columns, output in range plus 7 columns

4. DataGridView - refreshing calculated columns when move from column to column.

5. select range in column, calculate on range plus 3 columns, output inrange plus 7 columns

6. Calculating column A * column B = Results in another column

7. select range in column, calculate on range plus 3 columns, output in range plus 7 columns

8. custom chart type column - column on 2 y axes

9. Calculating Column and off setting calculated value to another column

10. Parent Columns and Child Columns don't have type-matching columns

11. Query Column A type and Column B type = cost

12. Tabbing from column to column to column in a 5 column document.

13. sum column and calculate numbers >0 in the same column with 1,5

14. I need a formula to calculate 2-3 columns but skip a column if

15. Insert text in column A and calculate the average from column

1 post • Page:**1** of **1**