Getting query is too complex error

[justice2003]

This is more of two questions. But my major problem is that I get the query is too complex error when I load up the form where this query is stored as a subform.

If I take out this part it works but I need something like this:
(Mid([combined_x_x]![nxx x x],[Forms]![blank_block_Search]![digits],1) Not In ([Forms]![blank_block_Search]![hiddenlist]))=True)

The hiddenlist field will be a list of numbers comma separated. such as 1,2,3. I know this part will work when I just load up the query and just put in one number for hiddenlist field but it doesn't work for multiple numbers.



here is my full query:

SELECT X_type.[NAME], combined_x_x.[nxx x x], X_type.Type, X_type.Cust_Data
FROM X_type INNER JOIN combined_x_x ON (X_type.X = combined_x_x.X) AND (X_type.NXX = combined_x_x.NXX)
WHERE (((Mid([combined_x_x]![nxx x x],[Forms]![blank_block_Search]![digits],1) Not In ([Forms]![blank_block_Search]![hiddenlist]))=True))
GROUP BY X_type.[NAME], combined_x_x.[nxx x x], X_type.Type, X_type.Cust_Data
HAVING (((X_type.Type) Is Null));

 

[dhookom]

It will never work as you expect it to. The query engine can't resolve the hidden list. You must use code or something to change the SQL of the query or use the Instr() function to determine if a single string value is located in another string value.

Duane
Hook'D on Access
MS Access MVP

 

[justice2003]

Thanks. That is what I ended up doing, and seems to work better now.