I want the records but not the field data **

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

Guest

I'm using a make-table query to create a table of 4 fields. For one of the
fields there is a set of criteria, where, if the criteria is met, I don't
want that field data. But, I do want ALL the records nonetheless.

I tried putting the criteria
(Not Like "000*" And Not Like "?? " And Is Not Null) in the criteria
spot of that field. But, instead of only getting the data I want, the query
is excluding all the records that don't fit the criteria and I'm losing
referential integrity.

Thoughts?
 
If you want all the rows from the source to appear in the new table, then
there should be nothing in the criteria. You would probably need to use a
Switch or IIf function if you want to vary what goes into the columns.
Alternatively, you could consider populating the new table with the values
from the source then running one or more update queries to remove the
unwanted column data.

Hope This Helps
Gerald Stanley MCSD
 
Thank you. I don't really know much about using functions, but I will have
to check it out. It does seem likely, that your latter suggestion will be
the process.

If I did use the IIF function, how/where do I do/enter it?

Jarrod
 
With the query in Design View, you would enter the function in the Field row.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top