OK I am designing a database thats due friday (already 2 weeks OD) and I thought I sorted this until I added some more criteria.
ok this is what its ment to do/ what happens.
The User enters criteria into the relevant boxes, leaving out the options they do not want to search on. (pic 1) they then press the run button which produces the report or shows the form for editing to results.
this works fine with a max of 4 or so search options, however as soon as the user runs it a few times or if I add another criteria to be included, I get the message "query to complex" and then it looks like this.