Comparing Multiple Values

Results 1 to 2 of 2

Thread: Comparing Multiple Values

  1. #1
    Join Date
    Dec 1969

    Default Comparing Multiple Values

    Is there anyway, I can test multiple values to see if they are null, besides looping through them or using an AND statement? Here&#039;s an example:<BR><BR>I wish I could use: If Isnull(A,B,C) then<BR>............<BR><BR>But I currently use : If Isnull(A) And Isnull(B) And..........<BR><BR>Can anyone help?<BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Comparing Multiple Values

    What I would do, is build a function that checks each parameter if it&#039;s null.... but then again.. this requires a loop/logic statements.... not really doing what you want I think.<BR><BR>I&#039;m not familiar with any function than can accept multi-values and give a boolean answer. Best bet is to write your own. Sorry.<BR><BR>Perhaps somebody, Bill, Ak know of one... <BR><BR>Vadim C.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts