Re: Query

Try this:


Select * from myquery where F1 = myform.F1 or F2 = myform.F2 or F3 =
myform.F3


Linda


"Brian" <Brian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:104CA575-6738-403A-96AB-D91C65F51CE8@xxxxxxxxxxxxxxxx
>I have a query with 12 fields from 4 differant tables, I'm need to get the
> user to search any of the fields, leaving some blank but still getting
> results from the blank fields. I can't seem to get the quey to run without
> asking for input from the fields that are blank. Any help would be
> welcome.
> Brian


.

Relevant Pages

  • Query
    ... I have a query with 12 fields from 4 differant tables, ... user to search any of the fields, leaving some blank but still getting ... Prev by Date: ...
    (microsoft.public.access.queries)
  • auto numbering primary key
    ... I am creating a new form from a query. ... Thanks for the previous responses to ... Linda ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Query filter criteria
    ... I want a query to show only those records based on today's date. ... other criteria I should be using? ... Linda ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Query filter criteria
    ... Usually if a query doesn't return rows, the criteria are off, or the data ... >> Jeff Boyce ...
    (microsoft.public.access.forms)
  • Re: Query filter criteria
    ... "Linda" wrote: ... >> date/time field? ... Can you list the SQL for the query? ... >> Access Database Samples: www.rogersaccesslibrary.com ...
    (microsoft.public.access.forms)