Urgent Help Required about Case in ACCESS 2010

haq39

New member
Local time
Today, 12:45
Joined
May 30, 2012
Messages
3
I want same results in access 2010 as mentioned in following sql statement


case
When ALLPOs.Delivery = Receiving.Pdate then "Same"
When ALLPOs.Delivery < Receiving.Pdate then "In Time"
When ALLPOs.Delivery > Receiving.Pdate then "LATE"
End case
 
Thanks JANR, I used Switch as follows but blanks column appears
Switch ( Receiving.Pdate>ALLPOs.Delivery,late, Receiving.Pdate=ALLPOs.Delivery, same, Receiving.Pdate<ALLPOs.Delivery,before )
 
You forgot quotes around the choises.

try:
Code:
 Switch([Receiving].[Pdate]>[Allpos].[Delivery],"Late",[Receiving].[Pdate]=[Allpos].[Delivery],"Same",[Receiving].[Pdate]<[Allpos].[Delivery],"Before")
JR
 

Users who are viewing this thread

Back
Top Bottom