Need Help with Crosstab Query

  • Thread starter Thread starter Accesshelp
  • Start date Start date
A

Accesshelp

Hello all,

I have the following 3 fields:

Student ID (Row Heading), School Year End (Column Heading) and Data (Value)

I create a crosstab query as indicated above. The problem that I have is
the Data field is alphanumeric, and I can not do Sum or Group By on the
field. So I choose First (Min or Max), and the query runs, but the data for
different School Year End do not group when the Student ID is the same.

How can I make it to group on the same line if the Student ID is the same?

Thanks.
 
You should be getting only one row per StudentID. Check the SQL view for
additional fields in the GROUP BY clause. If you can't correct this, reply
back with the SQL view.
 
Duane,

Thank you very much for your response. You are right! The data group into
one row per StudentID.

Since my data field is alphanumeric, I can not do Sum or Group By for the
Total. The options that I have are First, Last, Min or Max. I am just
wondering whichever the option (First, Min, etc.) that I choose, would the
records come out the same? I tested those options with a small group of
populations, and they came out the same. I just have a concern that when I
go live with mass data, they would not come out the same.

Thanks.
 
I expect there should only be one value per student per school year so it
doesn't make any difference if you use first or last or min or max.
 
I am just
wondering whichever the option (First, Min, etc.) that I choose, would the
records come out the same?
Click to expand...

The first of a set of one records will be... the one record.

Same with the other choices!
 
Back
Top