Calculated column from a Custom Type column

Calculated column from a Custom Type column

Post by Achuss AKA » Sat, 21 Jul 2007 18:14:43

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.

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.


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

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


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,

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