Re: Query to ignore other conditions

1. Create a query that selects the fields you want from the table(s) you
want.

2. type anything into the Criteria row under one of the fields.

3. Switch the query to SQL View (View menu).

4. Replace the line containing:
WHERE ...
with the WHERE clause from the previous post.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<sunilkeswani@xxxxxxxxx> wrote in message
news:1133277232.346518.272570@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Thanks Allen, sorry but could you please provide the complete code? the
> SELECT XX from XX ?
> I am no good at this, but I need to get this working..


.

Relevant Pages

  • Re: Query description property dynamically
    ... query descriptions worked again. ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ... >> error handling to catch it when the property doesn't exist. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using queries in if statements
    ... Bruce ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ... >> query that gives the number of records that are unmatched. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Setting Report Filter
    ... > Dawn, if you want the subqueries to read the same parameter, then use Method ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ... >> sub-report is based on the same query. ...
    (microsoft.public.access.reports)
  • Re: Criteria - Query
    ... Change the Criteria row in your query to: ... rather than allenbrowne at mvps dot org. ... >I have set up a database with a 'address' query. ...
    (microsoft.public.access.queries)
  • Re: sorting fields on a form
    ... form and not the one defined on the query. ... > Allen Browne - Microsoft MVP. ... Perth, Western Australia. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.formscoding)