SQL Cast函数语法错误 [英] SQL Cast Function Syntax Error

问题描述

有人能以此指导我正确的方向吗?我已经尝试过以各种方式编辑我的语法，并搜索了2小时的时间来完成这项工作.但是我无法使CAST功能正常工作.我在做什么错了?

Can anyone guide me in the right direction with this? I've tried editing my syntax every way possible and searched for 2 hours how to make this work. But I cannot get my CAST function to work properly. What am I doing wrong?

SELECT     dbo_orders.ordernumber, 
       dbo_orders.orderdate, 
       Sum([dbo_Order Details].priceperunit) AS sumofpriceperunit, 
       dbo_orders.producttotal, 
       Sum([dbo_Order Details].costperunit) AS sumofcostperunit, 
       dbo_orders.shippingtotal, 
       dbo_tracking.cost, 
       [dbo_Order Details].dropship, 
       dbo_orders.cartid 
CAST       ([dbo_Tracking].cost) AS number 
FROM       dbo_tracking 
INNER JOIN ([dbo_Order Details] 
INNER JOIN dbo_orders 
ON         [dbo_Order Details].ordernumber = dbo_orders.ordernumber) 
ON         dbo_tracking.numerickey = [dbo_Order Details].ordernumber 
GROUP BY   dbo_orders.ordernumber, 
       dbo_orders.orderdate, 
       dbo_orders.producttotal, 
       dbo_orders.shippingtotal, 
       dbo_tracking.cost, 
       [dbo_Order Details].dropship, 
       dbo_orders.cartid 
HAVING     ((( 
                                        dbo_orders.orderdate)>=(#6/1/2016#) 
                  AND        ( 
                                        dbo_orders.orderdate)<=(#6/30/2016#)));

推荐答案

msaccess强制转换函数

msaccess cast functions

Cint -- cast to integer
Clng -- long
Cdbl -- double
Csng - single
Cstr - string
Cbool - boolean

SELECT clng(fieldName) FROM tableName

https://www.techonthenet.com/access/functions/datatype /cint.php

添加了'，'，强制转换字段，删除了hading子句，并添加了where子句.您可能需要相应地格式化日期.

added ',' , cast the field, remove having clause and added where clause. you might want to format the date accordingly.

    SELECT     dbo_orders.ordernumber, 
           dbo_orders.orderdate, 
           Sum([dbo_Order Details].priceperunit) AS sumofpriceperunit, 
           dbo_orders.producttotal, 
           Sum([dbo_Order Details].costperunit) AS sumofcostperunit, 
           dbo_orders.shippingtotal, 
           dbo_tracking.cost, 
           [dbo_Order Details].dropship, 
           dbo_orders.cartid ,    'added a comma
    CInt       ([dbo_Tracking].cost) AS number  'cast accordingly
    FROM       dbo_tracking 
    INNER JOIN ([dbo_Order Details] 
    INNER JOIN dbo_orders 
    ON         [dbo_Order Details].ordernumber = dbo_orders.ordernumber) 
    ON         dbo_tracking.numerickey = [dbo_Order Details].ordernumber 

where   'added where clause
         dbo_orders.orderdate>=   (#6/1/2016#) 
   AND   dbo_orders.orderdate <=(#6/30/2016#)

    GROUP BY   dbo_orders.ordernumber, 
           dbo_orders.orderdate, 
           dbo_orders.producttotal, 
           dbo_orders.shippingtotal, 
           dbo_tracking.cost, 
           [dbo_Order Details].dropship, 
           dbo_orders.cartid 
 'removed having clause

这篇关于SQL Cast函数语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！