C ChrisDo11 Registered User. Local time Today, 05:02 Joined Jan 21, 2003 Messages 69 Feb 4, 2003 #1 i have a "DATE" feild in one of my tables formatted to: mmm d", "yyyy Is there anyway to have a default of "-" to show up in my report based on this table if no date is entered? Thanks,
i have a "DATE" feild in one of my tables formatted to: mmm d", "yyyy Is there anyway to have a default of "-" to show up in my report based on this table if no date is entered? Thanks,
V Vassago Former Staff Turned AWF Retiree Local time Today, 00:02 Joined Dec 26, 2002 Messages 4,748 Feb 4, 2003 #2 IIf([whateverdate] is null,"-",format(whateverdate, "mmm d, yyyy") See if that works, not quite sure as I can't test it right now. Vassago
IIf([whateverdate] is null,"-",format(whateverdate, "mmm d, yyyy") See if that works, not quite sure as I can't test it right now. Vassago
