Search results

  1. N

    Query Criteria: Perform a BETWEEN 2 numbers from a form

    I'm am trying to write criteria for a query to display records with a value between 2 numbers on my form. Also, if these boxes are Null, I want to display all records. I have done a similar thing with all of my other criteria in the query. I used the criteria: Like...
  2. N

    Filter Query Using Form...Please Help!

    I have a form set up to open a query and filter the results based on the selections in my form. However, I want to set it up to filter the results ONLY IF I make a selection in that control box on the form. Currently, if I make a selection in one box and do not select anything in the next, my...
  3. N

    Query HELP! Multi-Selection List box

    Is there any way to have multiple values from a multi-selection list box display in separate rows in a query instead of all in the same field separated by commas? Basically i want my query format to be like the format in the attached excel document. THANKS!
  4. N

    SubQuery? Multi-Select? Query Format Help

    Ok, bear with me on this explaination as it is hard to put into words, so i have a working database (attached below). The NewEntry form allows people to enter data for a new job. In this form I have a cascading combo box 'Materials' which displays the available materials when a plumbing...
Back
Top Bottom