Search results

KISS is a very good rule to live by :) I am definitely struggling although decidedly less so since vbaInet helped me solve my initial search problems... and simple would be great since I have to explain it all to my boss and not only how to use it but how it works in case she decides to change...

I can use or and did in my queries, but when I tried to code the initial form with OR statments it wouldn't ever return any results. As long as I have it coded for AND statements it will return results but all boxes have to have input to return any and there are times we don't need to see that...

One textbox that would enter the criteria (ie: 8.0, 10.0, etc?) and buttons that open queries... one for > and one for <? And that would enter the criteria across all three fields then? The R M and L? So it does what my current between boxes do or would it only enter criteria for one field? The...

Thanks Brian :) What I ended up doing is keeping my initial search form as is but added in six text boxes to do between values for each of the R M and L fields. Also since that only works for criteria we want to see across all three fields, I built a separate query (more than one actually) to...

I'm sorry, I guess I am just really not understanding. You said to create two queries for each operator. Operator being the conditional > and < correct? And I understand what you just said to be that I can create one textbox where the user inputs either > or <. Then the next text boxes...

Is that going to take a separate form then? or at least a command button for each query that I have to write? Thinking this through... that would mean the form as it is now, but with three more input boxes, one for R, M, and L and two more buttons to run two more queries, one for < and one for...

This isn't one search each time. I need to be able to pull all records where a student scored 8.0 in any of the three fields (R, M, L). I also need to be able to find all records where a student has a grade point level below 8.0 in any of the three fields. I also need to be able to see which...

R, M, and L each contain a value (grade level). EACH of the three fields we need to be able to search to find the records where a student is below 8.0 grade level, at or above 8.0 grade level, and at or above 10.0 grade level. So all three values need to be able to be searched on all three...

Thanks for explaining that. I get the putting it on one line just like the institution and pass lines are with their nulls. How do I incorporate the conditional statements?

Thought I would start a new thread for this one even though I'm building off the last issue. I have a single table db that now has a search form to find any combination of Institution, Pass/fail status, and begin and end dates. I am needing to now add in searches for some of the testing...

I've moved on to the next portion of building this database. Now that my search works on all paramters as needed, we need to add in a few more. This time searching on three fields all still in the main table. The fields are R, M, and L. Values are numeric with one decimal. We want to add this...

That was it, didn't have the form still open after running the query. Left it open this time and clicked the report and it was all there perfectly. Thanks again so much, you've been incredibly helpful!

Last question, how do I now tie this to a report? I had a report based on the query, but is it possible to send the results from the form to a report? LOL sorry, thought I was done :)

Success!! This has been the most informative experience I've had with this yet. Thank you so very much. This worked like a charm and I think it has shown me how to solve the issues in the bigger database I was building. I'm excited to try this out to see. You have been incredibly helpful and...

Ok putting that in now. DeadRecords is the name of the Table

(ResultDate Between Nz([Start:],DMin("ResultDate","DeadRecords")) And Nz([End:],DMax("ResultDate","DeadRecords") that is exactly what is in each Alt and it's in the control source. If I change it out to full references like in the query code will that fix it?

Thanks again. It all works except that I can't leave date blank and return results.

LOL looked great but sooo didn't work :) Must have set up something wrong on the form. And when I try to just run the query I get the following error... Ok I get the error when running the form... since it's based off the form of course it won't run on it's own... brain is turning to tapioca I...

Like this? WHERE ((Institution= [Forms]![Form1]![cboInstitution] OR [Forms]![Form1]![cboInstitution] Is Null) And (PASS=[Forms]![Form1]![cboPass] OR [Forms]![Form1]![cboPass] Is Null) And (ResultDate Between Nz([Forms]![Form1]![txtStart], [Forms]![Form1]![txtAltStart])) And...

WHERE ((Institution= [Forms]![Form1]![cboInstitution] OR [Forms]![Form1]![cboInstitution] Is Null) And (PASS=[Forms]![Form1]![cboPass] OR [Forms]![Form1]![cboPass] Is Null) And (ResultDate Between Nz([Start:],DMin("ResultDate","DeadRecords")) And Nz([End:],DMax("ResultDate","DeadRecords"))))...