Want to sort data from a table from rows into columns please help.

[benJAMin14]

I have a table that has two records I care about for this. The first is a primary key. The second is a score for that primary key 1-5. There are many of these records. I would like to have a query that displays all of the 1's in a column with their primary keys displayed. Then all of the 2's in the next column with their primary keys displayed and so on. Maybe this is a crosstab query but I am not sure.

[isladogs]

To clarify, your table has two fields. An ID field and the Score field.
Your suggestion would work for a crosstab query if you had at least 3 fields for the row heading, column heading and value.
You need at least one more field for your row heading(s) then use score as column heading and ID as value,

[June7]

You mean you have two 'fields' you care about.

These are scores for what?

The third field can be calculated. Consider:

TRANSFORM First(Table1.ID) AS FirstOfID
SELECT DCount("*","Table1","Score=" & [Score] & " AND ID < " & [ID])+1 AS GrpID
FROM Table1
GROUP BY DCount("*","Table1","Score=" & [Score] & " AND ID < " & [ID])+1
PIVOT Table1.Score;