Results 1 to 5 of 5
  1. #1
    banjo1t is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    9

    Report filtering

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

  2. #2
    banjo1t is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    9
    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??

  3. #3
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,684
    Have you tried

    Code:
    (Events.Gigdate >= Date()) AND (Events.Venue <> "CANCELLED")
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  4. #4
    banjo1t is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    9
    Quote Originally Posted by ssanfu View Post
    Have you tried

    Code:
    (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!!

  5. #5
    banjo1t is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    9
    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!!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report Filtering..
    By banjo1t in forum Reports
    Replies: 1
    Last Post: 01-24-2011, 06:56 AM
  2. Filtering a Report
    By musicalogist in forum Reports
    Replies: 12
    Last Post: 04-29-2010, 08:36 PM
  3. Filtering in a report
    By SIM_2009 in forum Reports
    Replies: 1
    Last Post: 10-06-2009, 04:22 AM
  4. Report Filtering
    By HM1 in forum Reports
    Replies: 2
    Last Post: 07-06-2009, 06:06 AM
  5. Filtering my report
    By ldarley in forum Reports
    Replies: 1
    Last Post: 09-05-2008, 09:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums