ACCESS FEED: Re: Re: [MS_AccessPros] If IsNull(OptionDate)

Rabu, 30 Desember 2015

Re: Re: [MS_AccessPros] If IsNull(OptionDate)

John-

It seems that IsNull won't work for date type.

Best Regards,

Kevin

From: John Viescas JohnV@msn.com [MS_Access_Professionals]
Date: 2015-12-31 00:02
To: MS_Access_Professionals
Subject: Re: [MS_AccessPros] If IsNull(OptionDate)

Kevin-

Where are you using this - in a query?

Only obvious thing is to put brackets around the field name:

IIf(IsNull([OptionDate]),"rptHotelBookingAskOption","rptHotelBookingExtendOption")

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Dec 30, 2015, at 4:50 PM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Dear All,
Please check this code: IIf(IsNull(OptionDate),"rptHotelBookingAskOption","rptHotelBookingExtendOption")
My problem is: if OptionDate is null, the the result won't be "rptHotelBookingAskOption". What's wrong with this code? Thanks.
Best Regards,
Kevin