W WinDancer Registered User. Local time Today, 06:31 Joined Oct 29, 2004 Messages 290 Nov 24, 2009 #1 This code won't run: DoCmd.ApplyFilter , "[CaseStatus]<>'Closed' AND [TickleDate]<>null" I want all CaseStatus that are NOT closed and all tickle dates that are NOT null Help, PLease? Thanks, Dave
This code won't run: DoCmd.ApplyFilter , "[CaseStatus]<>'Closed' AND [TickleDate]<>null" I want all CaseStatus that are NOT closed and all tickle dates that are NOT null Help, PLease? Thanks, Dave
boblarson Smeghead Local time Today, 06:31 Joined Jan 12, 2001 Messages 32,053 Nov 24, 2009 #2 DoCmd.ApplyFilter , "[CaseStatus]<>'Closed' AND NOT IsNull([TickleDate])"
boblarson Smeghead Local time Today, 06:31 Joined Jan 12, 2001 Messages 32,053 Nov 24, 2009 #3 Or DoCmd.ApplyFilter , "[CaseStatus]<>'Closed' AND [TickleDate] Is Not Null"
W WinDancer Registered User. Local time Today, 06:31 Joined Oct 29, 2004 Messages 290 Nov 24, 2009 #4 Perfect- thanks, Bob
boblarson Smeghead Local time Today, 06:31 Joined Jan 12, 2001 Messages 32,053 Nov 24, 2009 #5 WinDancer said: Perfect- thanks, Bob Click to expand... No problem!
