User Profile

Collapse

Profile Sidebar

Collapse
tjdoss
tjdoss
Last Activity: Dec 4 '06, 06:57 PM
Joined: Nov 22 '06
Location: Virginia
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • tjdoss
    replied to Filter Criteria in a Report
    in Access
    Actually, for the string that I provided, the header would appear like this:

    Rank: Battalion Chief
    Sex: Male
    Paramedic Status: Paramedic
    Race: White/Caucasian
    Sex: Male

    ((([Roster Query].Rank)="3") AND (([Roster Query].Assignment)="1 ") AND (([Roster Query].Sex)="1") AND (([Roster Query].Paramedic)="1" ) AND (([Roster Query].Race)="6")) OR...
    See more | Go to post

      Leave a comment:

    • tjdoss
      started a topic Filter Criteria in a Report
      in Access

      Filter Criteria in a Report

      I am trying to display the "Filter by Form" criteria in a Report (that displays the filtered information). I have an unbound textbox with [Forms]![RosterForm].[Filter] as the control source that will give me the Filter itself but I need to clean this up. I envisioned a listing in the header of the report that would list each of the categories (there are six) and the filter criteria specified for the category.

      This is a...
      See more | Go to post
      No activity results to display
      Show More
      Working...