Returnt he results of 2 boolean variables as one result

[Corey-g via AccessMonster.com]

Hi All,

I did search for this before posting but I didn't find what I was looking for.
..

I have a function (returning boolean) that in turn calls 2 more functions
(also returning boolean). I know I could do an if statement to see if both
are true and return true, otherwise false, but I got to thinking and I
figured there must be a shorter way to do this.

I had thought maybe math:
result = result1 + result2
but this wouldn't work the way I had thought (True + True = True) - rather -
1 + -1 = -2

Then I thought about the DMAX function (return the largest of the data set):
DMAX (True, False) = false (0)
DMAX (True, True) = True (-1)

but I read all over the these function s aren't a good idea to use over
otheres, so I thought I'd post the question...

Thanks in advance,

Corey

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200610/1

[pietlinden]

Corey-g via AccessMonster.com wrote:

Hi All,

I did search for this before posting but I didn't find what I was looking for.
.

I have a function (returning boolean) that in turn calls 2 more functions
(also returning boolean). I know I could do an if statement to see if both
are true and return true, otherwise false, but I got to thinking and I
figured there must be a shorter way to do this.

Function BothTrue(blnArg1 as boolean, blnArg2 as boolean) as boolean
BothTrue = blnArg1 And blnArg2
End Function

[Corey-g via AccessMonster.com]

I knew that there awas a shorter way than an if statement.

Thanks so much!!!

Corey

--
Message posted via http://www.accessmonster.com

[pietlinden]

Corey,
if your function is simple, you would be better off doing the
calculation in a query. Only use functions if you have to. For
example, if your function can take varied parameters and has complex
business logic.

You could easily do something like this in a query:

SELECT Field1, Field2, (booleanField1 AND booleanField2) AS
ReturnBoolean
FROM SomeTable...

won't really matter that much when you have a small DB, but the bigger
you get, the more important it is to use the best/most efficient tool
available.

HTH,
Pieter