Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Simple filter question (2000)

    Hi,
    I have a query that filters a field called 'Town' with [Forms]! [FrmReport]![Cbotown], so whatever the user selects in cboTown is reflected in the query and only those records are returned.
    However I'd also like the user to be able to select the blank from cboTown, and have the query not filter specifically to a selection, otherwise all records.
    Not too sure how to do this, presumably it needs to go into the criteria?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Simple filter question (2000)

    Possibility 1:

    Expand the criteria to

    [Forms]! [FrmReport]![Cbotown] Or [Forms]! [FrmReport]![Cbotown] Is Null

    Possibility 2:

    Cut [Forms]! [FrmReport]![Cbotown] from the criteria line and paste it into the Field row in the first blank column. Set the criteria for this new column to

    [Town] Or Is Null

    and clear the Show check box for this column (it is used only as a filter column).

    Note: when you save, close and reopen the query, Access may have rearranged the criteria. This is normal, and nothing to worry about.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Simple filter question (2000)

    Cheers, works a treat!! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •