[AccessD] If Then Else to Function

Nicholson, Karen cyx5 at cdc.gov
Wed Nov 10 10:20:55 CST 2004


I can not find any references to this on line or in books.  I have tasks
that fall into various buckets for users to process as they move through
an approval process.  The existing database defines these buckets using
if..then..else statements across more forms and reports than I can name.
Moving to the big time, how do I convert a statement show below to a
function?  This example defines if a task is in the AS Final Review
queue.

TaskStatus: IIf([RequestType] Not In ('Field Problem','Site
Audit','Product Audit','Product Audit/Field Problem') And [Section] In
(2,3) And [Status]='Open' And Not IsNull([ASSectCompletedDate]) And
[ysnASTestRequired]=0 And [ysnASQARequired]=0,"In AS Final Review","Not
In AS Final Review")



More information about the AccessD mailing list