I'm just learning SQL. I use MS Access and I can't find any reference to the
CAST function in HELP.

Is CAST used in MS Access 2003? If not, what is used in its place.

I wrote this simple query as part of an exercise in "SQL for mere mortals"
and I'm getting this message

Syntax error (missing operator) in expression 'CAST(ShipDate - OrderDate AS
INTEGER)'


Help!

You would be better off asking that question in an Access newsgroup, not in
an Excel newsgroup.
--
David Biddulph

"Matt S" wrote in message
...
I'm just learning SQL. I use MS Access and I can't find any reference to
the
CAST function in HELP.

Is CAST used in MS Access 2003? If not, what is used in its place.

I wrote this simple query as part of an exercise in "SQL for mere mortals"
and I'm getting this message

Syntax error (missing operator) in expression 'CAST(ShipDate - OrderDate
AS
INTEGER)'


Help!