CAST Function

M

Matt S

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!
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CAST function question 3
CAST does not work in MS Access 'rendition' of SQL 4
Query not working between Excel and Access 2
Help with MSQuery & CAST function 3
Using the Cast Extension Method To Convert To String 1
access query- get missing operator error 2
JOIN EXPRESSION 1
Specified cast error on an integer datatype 1

Top