if statement results

C

chartmaker

How can I make an "if" statement return an empty cell? (Not just a ""). A
chart based on those cells keeps giving me zero values
 
C

Chris O'C via AccessMonster.com

Select iif(Date() < dtExpires, null, "Subscription expired") as Expiration,
CustomerID
from Subscriptions;

Chris
Microsoft MVP
 
Top