如何把这句sql语句转化为access可用的？

SQL code:

select datename(weekday,riqi) as 星期,
CUSTOMER_ID,
CUSTOMER_NAME,
CUSTOMER_ADDRESS,
BUY_TIME,
BUY_TIMES,
WRITE_TIMES,
sum(CARD_EN) as CARD_EN,
sum(BUY_MONEY) as BUY_MONEY,
sum(BC_YSJE) as BC_YSJE,
sum(SUM_USE) as SUM_USE,
sum(REMAIN_EN) as REMAIN_EN,
convert(varchar(10),BUY_TIME,120) as [date]
from
T_BUT_RECORD
group by
CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,convert(varchar(10),BUY_TIME,120)

union all

select '总计',
CUSTOMER_ID,
CUSTOMER_NAME,
CUSTOMER_ADDRESS,
BUY_TIME,BUY_TIMES
,WRITE_TIMES,
sum(BUY_MONEY) as BUY_MONEY,
sum(BC_YSJE) as BC_YSJE,
sum(SUM_USE) as SUM_USE,
sum(REMAIN_EN) as REMAIN_EN,
convert(varchar(10),getdate(),120)
from T_BUT_RECORD
group by CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES



datename,convert,getdate,求救啊~~

---

select format(riqi,'DDD') as 星期,
    CUSTOMER_ID,
    CUSTOMER_NAME,
    CUSTOMER_ADDRESS,
    BUY_TIME,
    BUY_TIMES,
    WRITE_TIMES,
    sum(CARD_EN) as CARD_EN,
    sum(BUY_MONEY) as BUY_MONEY,
    sum(BC_YSJE) as BC_YSJE,
    sum(SUM_USE) as SUM_USE,