Query Criteria stored in a table

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

Guest

I have a make-table query that I run regularly to refresh my data base with
new data. The source data I use has some bad information and from time to
time new bad information comes in. I have a query set now to filter this bad
info out before the table is made. I use "not" statements in the criteria of
my query to exclude the bad data. Is there anyway to build a table that has
all of the data that I want to exclude. And then use the fields from this
table in the "not" statements of my query?
 
You can create a table with the values you want to exclude. Then use a
query that does a left join to that table. Add selection criteria that
compares for Null in the primary key field of the exclusion table. This
will return all rows from tblA where there is NO matching record in tblB.
 
Back
Top