Multiply Query

Hi All,

I was wondering how do i create a form type dialog with several
option, and depending on the options that are selected it filters out
the results,

Ive created a query, relating to me project table,

i have created a unbound form, and added all the required fields which
are combo's extra and the linked all the associated fields under the
criteria field on the query back to the dialog form i've created.

the dialog search form works fine, only if something is selected on
each field.

What I'm actualy asking is that if the a particular wanted to ignore
say the Quoted Combo and left it blank the query would display both
Quoted and Non Quoted projects, depending on what the other criteria
was used of course!

does that make sense?

.

Relevant Pages

  • Re: Referincing Fields
    ... depending on the path and there are about 50 of these types of fields I am ... a query that will create a single units field in my query that will ... than going in and trying to edit a nested Iff statement(I currently have ...
    (microsoft.public.access.modulesdaovba)
  • Re: Multiply Query
    ... criteria field on the query back to the dialog form i've created. ... depending on what the other criteria ... If some of these controls are textboxes which may be ... I have found it useful to divide up the SQL string into substrings ...
    (microsoft.public.access.formscoding)
  • Re: different results of query from different workstations
    ... The query converts a txt-field into a date format with the following ... General Date will have variable appearance depending on the computer's ... if your intention is to find all values more recent than 26 hours ago. ...
    (microsoft.public.access.queries)
  • Re: Classes functions....help!
    ... Not to take anything away from what Kevin said, but one possibility, ... depending on your database type/design, you could construct a query as such: ...
    (microsoft.public.dotnet.framework.aspnet)
  • filter a text box through a combo box on a form
    ... I would like to know how to filter the information displaying on a text box ... depending on the value of a combo box. ... I Have a query that displays the strSku and Quantity from my Production table ...
    (microsoft.public.access.gettingstarted)