How can I make a crosstab without using an aggregate function

[George Chen]

Hello,

I am starting with multiple tables. The column names are: protein, signal,
sample. Sample is the same for each table (all the proteins and signals come
from the same sample).

I would like to combine data from the multiple tables such that the fields
in protein become the row names and the fields in sample become the column
names. I want signal to show up at the intersection of the two.

I have tried doing this with crosstab, but Access always wants to perform
somekind of aggregate function on signal. I just want signal to be copied
over.

Is there a way to do this?

Thanks for your help.

 

[KARL DEWEY]

Post sample data from the tables and an example of what you want the results
to look like.

 

[Douglas J. Steele]

If you've only got a single signal value, use Max (or Min) as the Aggregate
function.

 

[MGFoster]

Hello,

I am starting with multiple tables. The column names are: protein, signal,
sample. Sample is the same for each table (all the proteins and signals come
from the same sample).

I would like to combine data from the multiple tables such that the fields
in protein become the row names and the fields in sample become the column
names. I want signal to show up at the intersection of the two.

I have tried doing this with crosstab, but Access always wants to perform
somekind of aggregate function on signal. I just want signal to be copied
over.

Is there a way to do this?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If there's only one signal per protein/sample you can use the SUM() or
FIRST() aggregate functions. They will just return that one value.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBScLPk4echKqOuFEgEQLbGACg6a9jPyb7kdBDB1h1Cf0Ih6Eg/vEAnRz0
FVw4voEYMDzG9neqZ+FTm8me
=XN3K
-----END PGP SIGNATURE-----