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??