Report filtering

[banjo1t]

Further to my previous thread,
I have created a filter by the following...


(((Events.Gigdate)>Date()) AND (Not (Events.Venue)="CANCELLED")

This filter works BUT it now excludes all records that fall on the same day
other records have the string "CANCELLED" in them...

Any ideas why this happens??

[banjo1t]

I'm still having problems with this filter.....

Events.[Gigdate]>Now() And Not Events.[Venue]="CANCELLED"

The report lists all future gigs, and removes any with the CANCELLED string in them,
however other records that DO NOT have the CANCELLED string in them,
for some reason do not display if they are on the same day??

[ssanfu]

Have you tried

(Events.Gigdate >= Date()) AND (Events.Venue <> "CANCELLED")

[banjo1t]

Have you tried

(Events.Gigdate >= Date()) AND (Events.Venue <> "CANCELLED")

Thanks for quick reply,

I've tried it and it comes up with the same result!?

i.e. Any record that falls on the same day as a record with the string 'CANCELLED' in them are also not displayed!!

[banjo1t]

I have since found out, if the other records have a null string, these are also omited, as long as you have something in the record it works!!!