Last Part of query not working!

R

Rick Brandt

AG said:
Instead of [MaxOfBillDate]=Null use IsNull([MaxOfBillDate]).
Click to expand...

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.
 
L

Levar

Bob Vance said:
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
Click to expand...
 
B

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
 
A

AG

Thanks Rick - didn't realize that!

--

AG
Email: discussATadhdataDOTcom
Rick Brandt said:
AG said:
Instead of [MaxOfBillDate]=Null use IsNull([MaxOfBillDate]).
Click to expand...

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.
Click to expand...
 
B

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")
 
Top