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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Back
Top