MS ACCESS VBA按案例订购的时间 [英] MS ACCESS VBA ORDER BY CASE When

问题描述

我很多orders in my Factory.

我们完成工作的正常时间是10天，但有时我们向客户保证会缩短工作时间(假设5天).

Our regular time to finish our job is 10 days but sometimes we promise to the customer that it will be shorter (lets assume 5 days).

我试图建立一个按minimum Date of the two columns顺序排列的SQL:

I tried to build an SQL that order by the minimum Date of the two columns:

SELECT id, Status, DeliveryDate, PromiseDate
FROM CustomerOrderT
WHERE Status > 2 and Status <7 
ORDER BY CASE WHEN DeliveryDate > PromiseDate then PomiseDate ELSE DeliveryDate END;

但是我从ms访问中收到一条问题消息.也许写正确 问题按摩贴

But i get a problem message from ms access. maybe write it correctly The problem massage attached

谢谢

推荐答案

在MS Access中，您必须使用IIF代替Case，例如:

In MS Access you have to use IIF instead of Case like this:

SELECT id, Status, DeliveryDate, PromiseDate
FROM CustomerOrderT
WHERE Status > 2 and Status <7 
ORDER BY IIF(DeliveryDate > PromiseDate, PromiseDate, DeliveryDate);

这篇关于MS ACCESS VBA按案例订购的时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！