re-arranging the data in an access table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access table, which contains the data in a format like this:

group ID # of office visit
A 5
A 9
B 5
B 6
A 7


I want to re-arrange the data, so I can calculate the median, mean, and mode
of each group in either excel or access

I want the dat to look like this:
A B
5 5
9 6
7

How can I do that?

Thanks!
 
You don't want to do this in a table. Instead you want to create a crosstab
query. One problem is that you need at least three fields in your table for a
crosstab to work.
 
Crosstab would not work, because I have to either do sum, var, or std dev..etc.

any other options?
Thanks!
 
This is near impossible without another field or value that links the first
A with the first B. I expect you are holding back on some fields.
 
I have member's ID. Would that help?

The table is like this:
member's ID, Group ID, number of office visit.

Thanks.
 
Depends on if the MembersID is unique. You need to be able to create a
record set like:
Seq group ID # of office visit
1 A 5
2 A 9
1 B 5
2 B 6
3 A 7

This can generally be created with DCount().
 
Back
Top