Last Part of query not working!

[AG]

Instead of [MaxOfBillDate]=Null use IsNull([MaxOfBillDate]).

 

[Rick Brandt]

Instead of [MaxOfBillDate]=Null use IsNull([MaxOfBillDate]).

Actually in a query one should use...

[MaxOfBillDate] Is Null

The IsNull() function is for use in VBA and while a query in Access will
process it (as it would most other VBA functions), it must invoke the
expression service to do so. As long as there is a pure Jet way to handle
it that is the preferred method.

 

[Levar]

LastPayment: Switch(DateDiff("d",[MaxOfBillDate],Date())<30 And
[Payable]>1,Null,DateDiff("d",[MaxOfBillDate],Date())<60 And
[Payable]>1,"1",DateDiff("d",[MaxOfBillDate],Date())<90 And
[Payable]>1,"2",DateDiff("d",[MaxOfBillDate],Date())<120 And
[Payable]>1,"3",DateDiff("d",[MaxOfBillDate],Date())>121 And
[Payable]>1,"+4",[MaxOfBillDate]=Null And [Payable]>1,"NoDate")

This quey is working except for this part
[MaxOfBillDate]=Null And [Payable]>1,"NoDate"
It is showing blank and not "NoDate"
Thanks for any Help........Bob

 

[Bob Vance]

LastPayment: Switch(DateDiff("d",[MaxOfBillDate],Date())<30 And
[Payable]>1,Null,DateDiff("d",[MaxOfBillDate],Date())<60 And
[Payable]>1,"1",DateDiff("d",[MaxOfBillDate],Date())<90 And
[Payable]>1,"2",DateDiff("d",[MaxOfBillDate],Date())<120 And
[Payable]>1,"3",DateDiff("d",[MaxOfBillDate],Date())>121 And
[Payable]>1,"+4",[MaxOfBillDate]=Null And [Payable]>1,"NoDate")

This quey is working except for this part
[MaxOfBillDate]=Null And [Payable]>1,"NoDate"
It is showing blank and not "NoDate"
Thanks for any Help........Bob

 

[AG]

Thanks Rick - didn't realize that!

--

AG
Email: discussATadhdataDOTcom

Instead of [MaxOfBillDate]=Null use IsNull([MaxOfBillDate]).

Actually in a query one should use...

[MaxOfBillDate] Is Null

The IsNull() function is for use in VBA and while a query in Access will
process it (as it would most other VBA functions), it must invoke the
expression service to do so. As long as there is a pure Jet way to handle
it that is the preferred method.

 

[Bob Vance]

I suppose this will do it ..........Thanks Bob
LastPayment: Switch(DateDiff("d",[MaxOfBillDate],Date())<30 And
[Payable]>1,Null,DateDiff("d",[MaxOfBillDate],Date())<60 And
[Payable]>1,"1",DateDiff("d",[MaxOfBillDate],Date())<90 And
[Payable]>1,"2",DateDiff("d",[MaxOfBillDate],Date())<120 And
[Payable]>1,"3",DateDiff("d",[MaxOfBillDate],Date())>121 And
[Payable]>1,"+4",[MaxOfBillDate] Is Null And [Payable]>1,"NoDate")