Requirements for using queries as filters

A query must meet certain requirements if you're going to use it as a filter. The query:

• Must be based on the same underlying table or query as the datasheet or form to which you're applying it.
  
  
• Can't include other tables or queries.
  
  
• Must be a select query (not a crosstab query or action query).
  
  
• Can't include fields that sum, count, or calculate another type of total for the values in a field.