Putting multiple items into a single column in a datagrid

Putting multiple items into a single column in a datagrid

Post by Dizzi » Sun, 20 Apr 2008 07:43:46

So I can put information into a datagrid, I can select a row and make sure
that it populates that row. I can even make it hit that specific row and column.

How do I got about having several different buttons all writing in the same
column? And perhaps even ordering it? i.e. The column would look like this:
buttonOneInput, buttonTwoInput, buttonThreeInput etc etc

I'd also like to sort the way this information goes in (just being able to
sort by alpha right now would be fine, but better yet if I could sort it so
button one always was in the front, button two always in the middle, button
three always in the end)
The end application of this is that I need to populate a datagrid with several
different button groups, there are 5 groups, each group contains about 10
buttons. The groups need to appear in a specific order in the datagrid, and I
need to be able to add as many button's information to the grid as possible.

After this stuff all goes in, I need to get it back out too. I think I'll be
able to figure that part out.

Now, I know this is a lot of stuff. I don't even know if it's possible, but it
seems like it should be, I've been trying to figure it out all day to no avail.

Any tips / suggestions / code snippets / links to tutorials would be helpful.


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. Sending E-mail A's another user (Sent Items)

4. best way to sum a column with #N/a's?

5. Combine Multiple Rows single column into multiple column single ro

6. Combine Multiple Rows single column into multiple column single row

7. Importing CSV file into single column/multiple rows vs. multiple rows/single column

8. Combine Multiple Rows single column into multiple column single ro

9. Try Again / VLOOKUP without N/A's

10. Host would occasionally fail to resolve A's rec.Help!

11. Printing report b after report a prints using report a's variables

12. Why does Form-A's instance fire Form-B's event??

13. using "if" but omitting the #n/a's

14. equation that will filter out #N/A's

15. lookup only finds #n/a's