Re: re-arranging the data in an access table

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.

--
Duane Hookom
MS Access MVP

"Lan" <Lan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BAF46375-5B7D-467A-8F24-7D412FAF4C81@xxxxxxxxxxxxxxxx
Crosstab would not work, because I have to either do sum, var, or std
dev..etc.

any other options?
Thanks!

"Jerry Whittle" wrote:

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.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Lan" wrote:

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!


.

Relevant Pages

  • Re: re-arranging the data in an access table
    ... MS Access MVP ... "Duane Hookom" wrote: ... "Jerry Whittle" wrote: ... crosstab to work. ...
    (microsoft.public.access.queries)
  • Re: re-arranging the data in an access table
    ... "Duane Hookom" wrote: ... MS Access MVP ... "Jerry Whittle" wrote: ... crosstab to work. ...
    (microsoft.public.access.queries)
  • Re: query to split data in a column into two separate columns
    ... One of those is probably the field name, the others are misspellings. ... there is no address2 field in the tables that you are referencing. ... Access MVP 2002-2005, 2007 ... Jerry Whittle, Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Table Manipulation
    ... crosstab would work if the number of "fields" is not consistent. ... >>MS Access MVP ... >>>>Use this query as the basis for a maketable query. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Crosstab Situation
    ... Crosstab queries, ... My only question at this point would be on how to use a Union query for the ... "Duane Hookom" wrote: ... >>> MS Access MVP ...
    (microsoft.public.access.modulesdaovba)