L
Lorian
2 questions:
1. I created a parameter query that prompts the user for up to 7 different
parameters, and set it up so that if the user leaves any of the parameters
blank, it will return all the records that meet the remaining criteria (by
using the WHERE function - thanks, all, especially Tom). All was fine with it
yesterday, but today when I opened it, i got the 'Query too complex' error.
So I had to recreate it, and it worked ok again. What's up with that, and how
do i avoid having to recreate it?
2. I created a form to run the query (thanks again, Tom!), so I modified the
query to allow for the null parameters (by using the WHERE expression), but
now I'm seeing the 'undefined function 'WHERE' in expression' error. I'm just
using the standard front end functions - no code.
How can i fix these? Thanks for any help you can provide!
1. I created a parameter query that prompts the user for up to 7 different
parameters, and set it up so that if the user leaves any of the parameters
blank, it will return all the records that meet the remaining criteria (by
using the WHERE function - thanks, all, especially Tom). All was fine with it
yesterday, but today when I opened it, i got the 'Query too complex' error.
So I had to recreate it, and it worked ok again. What's up with that, and how
do i avoid having to recreate it?
2. I created a form to run the query (thanks again, Tom!), so I modified the
query to allow for the null parameters (by using the WHERE expression), but
now I'm seeing the 'undefined function 'WHERE' in expression' error. I'm just
using the standard front end functions - no code.
How can i fix these? Thanks for any help you can provide!