How to override a faulty query; open the design view to repair it

Hi,
I added a parameter to a query that I designed. Now I get error 3071
stating: This expression is typed incorrectly, or it is too complex to be
evaluated." So, how do I gain access to the query design window to repair it?
All that I wanted to do initially was display all records less than number 99
and now I can't even fix the mess.

I'm not sure I understand that question correctly, open the query in design
view, from the menu bar select query parameters, and remove that parameter

Unless the query build that way
Select * From TableName Where FieldName [Select Number]
Then remove the where statement.

What do you mean, that you have no access to the sql?
--
I hope that helped
Good luck


"J@50N-5ALTR" wrote:

Hi,
I added a parameter to a query that I designed. Now I get error 3071
stating: This expression is typed incorrectly, or it is too complex to be
evaluated." So, how do I gain access to the query design window to repair it?
All that I wanted to do initially was display all records less than number 99
and now I can't even fix the mess.