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.