RE: Using an option group to display a subform

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Jason,
Yes, you can add the WHERE clause to your query for filtering the records
according to your specific condition. Did you encounter any problem when
you use it?

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================



.

Relevant Pages

  • Re: Filter in the Join vs Filter in the Where
    ... And since your query and Bob's query both return the same result, it is not suprising that the optimizer generates the same plan. ... requires filtering to be applied to various columns from these various ... I will more often than not use the Join On to join the common ... and place any filters in the Where clause. ...
    (microsoft.public.sqlserver.programming)
  • Filter in the Join vs Filter in the Where
    ... this is with SQL Server 2005 data. ... requires filtering to be applied to various columns from these various ... and place any filters in the Where clause. ... might write a query like this: ...
    (microsoft.public.sqlserver.programming)
  • Re: Query
    ... Another way to do this is to use an Exists clause. ... FROM Demographic as D INNER JOIN Encounter as E ... Save that and then use it in a summary query. ... > primary key, and the two tables are linked by this key. ...
    (microsoft.public.access.queries)
  • Re: Date Range Totals for Logical Fields
    ... I'm sorry if I was not clear, but the test query ... based on how the filtering was working for you. ... it becomes a STRING (and so will sort/filter as ... "I put the where clause under the Group by Lead Date" ...
    (microsoft.public.access.queries)
  • Re: case statement in where
    ... :> quez wrote: ... I would run the select with no where clause (maybe restrict it based on ... clause is filtering out that row. ... query precisely so I can easy check the ...
    (comp.databases.oracle.server)