how do I get around the criteria limit when making a query

[searae]

I have a query I'm trying to run and I'm trying to use the Not Like formula to extract several records that I don't need. I'm talking about approximately 100 pieces of information (combinations of letters and numbers). I keep getting the error that the query only excepts approximately 1000 characters in the criteria exceptions column. Does any one know a way around this?

 

[dhookom]

You should set up a table with the values you don't want included. Seems to me you should be managing data records, not expressions.

For instance, if you have a table of projects and a table of work performed on those projects and you wanted to ignore specific projects from a report:

Create a table tblIgnoreProjects and add all the ProjectIDs that you want to ignore. You can then use this table in your query to exclude them.

When your list changes, you edit records, not expressions.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

Can you be more specific about your criteria ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244