Results 1 to 3 of 3
  1. #1
    yes sir is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    159

    Criteria for Report/Query being ignored

    I have a report with a record source based on a query that has certain criteria that must be met in a particular field. However, this criteria is being ignored in 4 of the 5 reports. These five reports are similar except that they are dividing all the records up into the five separate reports based on this one field. The only one that is working, is the one whom's data is showing up on the other four reports.

    Do I need to show more, or can anyone tell what is going on here? All five reports have their own separate record source.

    I have a feeling I might have to explain more.

  2. #2
    yes sir is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    159
    Ok. Here is the whole enchilada.

    I have 5 reports based on all of the basketball player's positions. So there are five positions (Center, Power Forward, Small Forward, Shooting Guard, and Point Guard).

    I have a query for each set to show only one position. So the Position field is one with the criteria. However, I also have a Rank field. For this specific report, I assign a certain value to the rank column. So I have some criteria in the rank column as well.

    What seems to be happening, is that all five of the reports are just meeting the Rank Criteria and completely ignoring the Position criteria. Of course, my reports are being sorted by rank. However, I messed with one of my queries and sorted by position, and then sort by rank, however I still have Power Forwards showing up on my other position reports.

  3. #3
    yes sir is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    159
    Well, apparently, I have to add a Filter to each Report's properties. Which seems stupid.

    Can anyone explain why my Position criteria is being ignored for the reports?

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

Similar Threads

  1. Query Criteria
    By Alex Motilal in forum Queries
    Replies: 2
    Last Post: 10-06-2010, 08:20 AM
  2. Want certain criteria to appear on report.
    By kenanselo in forum Reports
    Replies: 4
    Last Post: 01-18-2010, 02:48 PM
  3. Run Report with Prompt for Field Criteria
    By diane802 in forum Reports
    Replies: 4
    Last Post: 01-15-2010, 02:31 AM
  4. Replies: 1
    Last Post: 10-11-2009, 08:31 PM
  5. Replies: 6
    Last Post: 09-25-2009, 12:40 PM

Posting Permissions

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