1

I have 4 field in my table :

NO. | Specification | Specification Value | Description

1      Color               Blue             a
1      Size                 6"              a
2      Color               Red              b
2      Size                 8"              b

I am trying to Pivot it and its giving me an error.

TRANSFORM FIRST(Specification Value)
SELECT items.'No.'
FROM items
GROUP BY items.'No.'
PIVOT Specification

The error is : "Syntax error(missing operator) in query expression 'FIRST(Specification Value)'."

Please help. Thank you

jraic
  • 53
  • 1
  • 11

1 Answers1

0

Remove the space in the Specification Value. The First() function takes one expression or argument. You are passing it two, so it thinks you are passing an expression with two arguments and have forgotten the operator.

teylyn
  • 34,374
  • 4
  • 53
  • 73
  • Thank you Teylyn, the space was not the problem. I was missing an operator -> first(`Specification Value`) – jraic May 26 '15 at 15:47