Code:
TRANSFORM First(MyValue) AS FirstMyValue SELECT PrimaryKeyID FROM MyTable GROUP BY PrimaryKeyID PIVOT MyType;
nullgumby
Last Activity: Nov 10 '06, 08:17 PM
Joined: Nov 9 '06
Location:
-
That's what I did! :D ...this seems to work:
... -
I don't immediately see anything wrong with it either...one thought though, there might be an error in your SQL that's throwing an internal error in Access--since the SQL isn't valid.
On the line that's blowing up, I'd check the SQL in the immediate window. Maybe try to paste it and save it in a new query window to see if Access has a problem with it....Leave a comment:
-
Sql, Transform/pivot
Working in Access 2003.
I'm trying to write a query and have been looking at the TRANSFORM and PIVOT keywords, but can't seem to get them connected right.
My table is like this:
I want the results to look like this:Code:PrimaryKeyID MyType MyValue 1 Fruit Apple 1 Veggie Tomato 1 Meat Chicken 2 Fruit Orange 2 Veggie Potato 3 Fruit Banana
...Code:PrimaryKeyID
No activity results to display
Leave a comment: