Results 1 to 2 of 2

Thread: Report Filter

  1. #1
    Join Date
    Jun 2009

    Unanswered: Report Filter

    I have a table with 15 fields. One of my fields can have three options, Yes/No/TBD.

    I want to run a report that only shows the records that has TBD for this specific field.

    How do I go about doing that?

    Thanks for any help and sorry for my lack of knowledge, I am new to the reporting aspect of Access.


  2. #2
    Join Date
    Jul 2009
    set a query with all the tables then add the where for the one field to = tbd
    run your report off the query
    so if fields where
    field 1, field 2, field 3
    in the wizard you'd click the expression button at the top the add field 3 a second time with the where statement instead of the group by and put tbd in the criteria

Posting Permissions

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