Reusable statements in queries

[t2b]

Many queries in a database I am working in may have the same statement such as:

NewValue: IIf([Field1] Is Null,[Field2],[Field1])

What is the best way to store and call statements such as this?

 

[a a r o n . k e m p f]

put your logic inside SQL Server and just use User-Defined Functions.

 

[Access Developer]

I've heard of Johnny One-Note
(http://www.stlyrics.com/lyrics/babesinarms/johnnyonenote.htm) but, lo and
behold, here's Aaron One-Answer haunting the zombie newsgroups with his
one-and-only answer: "switch to SQL Server". Of course, he neglects to
mention that you can use functions in Access, Jet and ACE, without having to
switch.

Things must be really slow in Aaron's neighborhood if he has to try to trash
already-cancelled Microsoft-sponsored newsgroups. Hope you have a better
weekend than the week that drove you here, Aaron.

--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

put your logic inside SQL Server and just use User-Defined Functions.

Many queries in a database I am working in may have the same statement
such as:

NewValue: IIf([Field1] Is Null,[Field2],[Field1])

What is the best way to store and call statements such as this?