Update Query

[ksaab]

Question: How do I write a (very Large) query to exclude any updates where the "from" field is null ? Must I alter each Criteria line manually? I am lazy and trying to avoid this...can I write a script or macro to do this each time I need one of these large queries? Any help appreciated....

 

[pdx_man]

What is the SQL for your query? Have you tried Not Is Null

 

[ksaab]

I can do "Not is Null" for several strings but must do it on so many that it makes the Query too slow. I end up with several boolean OR's. I am hoping t o find a way to update based only on incoming values being "Not null" as a rule or script.

 

[pdx_man]

Have a SELECT query with all of your other criteria, then create the UPDATE query that also uses this query. Then add your NOT IS NULL criteria to this new query.