Joining Conditional Expressions

S

Sokan33

I used the following statement in my form to return a Yes or No to a field
named DueForAnnoitment
=IIf(([PeriodLastAnnoited]>2),"Yes","No") It work quite alright.

My Objective:
I have a Yes/No field named Baptised. I want this field to be additional
factor for DueForAnnoitment field so that 2 yes answers are required to
return YES.

I tried the following as the Contgrol Source for DueForAnnoitment field.
=IIf(([PeriodLastAnnoited]>2),"Yes","No") And (([Baptised]=Yes),"Yes","No")
It returns negative # ie -1 instead of Yes or No

Your help wiil be appreciated!
 
6

'69 Camaro

Hi.
I have a Yes/No field named Baptised. I want this field to be additional
factor for DueForAnnoitment field so that 2 yes answers are required to
return YES.
Click to expand...

Try:

=IIf(([PeriodLastAnnointed]>2) And ([Baptised]=True),"Yes","No")


HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are [email protected] and [email protected]

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.


Sokan33 said:
I used the following statement in my form to return a Yes or No to a field
named DueForAnnoitment
=IIf(([PeriodLastAnnoited]>2),"Yes","No") It work quite alright.

My Objective:
I have a Yes/No field named Baptised. I want this field to be additional
factor for DueForAnnoitment field so that 2 yes answers are required to
return YES.

I tried the following as the Contgrol Source for DueForAnnoitment field.
=IIf(([PeriodLastAnnoited]>2),"Yes","No") And (([Baptised]=Yes),"Yes","No")
It returns negative # ie -1 instead of Yes or No

Your help wiil be appreciated!
Click to expand...
 
S

Sokan33

I tried as you suggested but got the following return:
#Name?

Problem remains. Help still needed. Thx.

'69 Camaro said:
Hi.
I have a Yes/No field named Baptised. I want this field to be additional
factor for DueForAnnoitment field so that 2 yes answers are required to
return YES.
Click to expand...

Try:

=IIf(([PeriodLastAnnointed]>2) And ([Baptised]=True),"Yes","No")


HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are [email protected] and [email protected]

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.


Sokan33 said:
I used the following statement in my form to return a Yes or No to a field
named DueForAnnoitment
=IIf(([PeriodLastAnnoited]>2),"Yes","No") It work quite alright.

My Objective:
I have a Yes/No field named Baptised. I want this field to be additional
factor for DueForAnnoitment field so that 2 yes answers are required to
return YES.

I tried the following as the Contgrol Source for DueForAnnoitment field.
=IIf(([PeriodLastAnnoited]>2),"Yes","No") And (([Baptised]=Yes),"Yes","No")
It returns negative # ie -1 instead of Yes or No

Your help wiil be appreciated!
Click to expand...
Click to expand...
 
6

'69 Camaro

Sorry. Still had a typo (an extra parenthesis) in my copy buffer when I
pasted it into the message box. Try this:

=IIf((([PeriodLastAnnointed]>2) And ([Baptised])),"Yes","No")


HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.


Sokan33 said:
I tried as you suggested but got the following return:
#Name?

Problem remains. Help still needed. Thx.

'69 Camaro said:
Hi.
I have a Yes/No field named Baptised. I want this field to be additional
factor for DueForAnnoitment field so that 2 yes answers are required to
return YES.
Click to expand...

Try:

=IIf(([PeriodLastAnnointed]>2) And ([Baptised]=True),"Yes","No")


HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are [email protected] and [email protected]

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.


Sokan33 said:
I used the following statement in my form to return a Yes or No to a field
named DueForAnnoitment
=IIf(([PeriodLastAnnoited]>2),"Yes","No") It work quite alright.

My Objective:
I have a Yes/No field named Baptised. I want this field to be additional
factor for DueForAnnoitment field so that 2 yes answers are required to
return YES.

I tried the following as the Contgrol Source for DueForAnnoitment field.
=IIf(([PeriodLastAnnoited]>2),"Yes","No") And (([Baptised]=Yes),"Yes","No")
It returns negative # ie -1 instead of Yes or No

Your help wiil be appreciated!
Click to expand...
Click to expand...
Click to expand...
 
6

'69 Camaro

Or even:

=IIf((([PeriodLastAnnointed]>2) And ([Baptised]=True)),"Yes","No")

It's a matter of personal preference that I leave off the "=TRUE"
expression, but if you ever need to change this equation to FALSE, having the
placeholder for where the "=FALSE" is going to be typed makes for a quick and
easy change.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


'69 Camaro said:
Sorry. Still had a typo (an extra parenthesis) in my copy buffer when I
pasted it into the message box. Try this:

=IIf((([PeriodLastAnnointed]>2) And ([Baptised])),"Yes","No")


HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.


Sokan33 said:
I tried as you suggested but got the following return:
#Name?

Problem remains. Help still needed. Thx.

'69 Camaro said:
Hi.

I have a Yes/No field named Baptised. I want this field to be additional
factor for DueForAnnoitment field so that 2 yes answers are required to
return YES.

Try:

=IIf(([PeriodLastAnnointed]>2) And ([Baptised]=True),"Yes","No")


HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are [email protected] and [email protected]

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.


:

I used the following statement in my form to return a Yes or No to a field
named DueForAnnoitment
=IIf(([PeriodLastAnnoited]>2),"Yes","No") It work quite alright.

My Objective:
I have a Yes/No field named Baptised. I want this field to be additional
factor for DueForAnnoitment field so that 2 yes answers are required to
return YES.

I tried the following as the Contgrol Source for DueForAnnoitment field.
=IIf(([PeriodLastAnnoited]>2),"Yes","No") And (([Baptised]=Yes),"Yes","No")
It returns negative # ie -1 instead of Yes or No

Your help wiil be appreciated!
Click to expand...
Click to expand...
Click to expand...
 
S

Sokan33

@?@ Hurray!!!!!!!!!!!!! It work perfectly. Thank you

'69 Camaro said:
Or even:

=IIf((([PeriodLastAnnointed]>2) And ([Baptised]=True)),"Yes","No")

It's a matter of personal preference that I leave off the "=TRUE"
expression, but if you ever need to change this equation to FALSE, having the
placeholder for where the "=FALSE" is going to be typed makes for a quick and
easy change.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


'69 Camaro said:
Sorry. Still had a typo (an extra parenthesis) in my copy buffer when I
pasted it into the message box. Try this:

=IIf((([PeriodLastAnnointed]>2) And ([Baptised])),"Yes","No")


HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.


Sokan33 said:
I tried as you suggested but got the following return:
#Name?

Problem remains. Help still needed. Thx.

:

Hi.

I have a Yes/No field named Baptised. I want this field to be additional
factor for DueForAnnoitment field so that 2 yes answers are required to
return YES.

Try:

=IIf(([PeriodLastAnnointed]>2) And ([Baptised]=True),"Yes","No")


HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are [email protected] and [email protected]

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.


:

I used the following statement in my form to return a Yes or No to a field
named DueForAnnoitment
=IIf(([PeriodLastAnnoited]>2),"Yes","No") It work quite alright.

My Objective:
I have a Yes/No field named Baptised. I want this field to be additional
factor for DueForAnnoitment field so that 2 yes answers are required to
return YES.

I tried the following as the Contgrol Source for DueForAnnoitment field.
=IIf(([PeriodLastAnnoited]>2),"Yes","No") And (([Baptised]=Yes),"Yes","No")
It returns negative # ie -1 instead of Yes or No

Your help wiil be appreciated!
Click to expand...
Click to expand...
Click to expand...
 
6

'69 Camaro

You're welcome!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


Sokan33 said:
@?@ Hurray!!!!!!!!!!!!! It work perfectly. Thank you

'69 Camaro said:
Or even:

=IIf((([PeriodLastAnnointed]>2) And ([Baptised]=True)),"Yes","No")

It's a matter of personal preference that I leave off the "=TRUE"
expression, but if you ever need to change this equation to FALSE, having
the
placeholder for where the "=FALSE" is going to be typed makes for a quick
and
easy change.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


'69 Camaro said:
Sorry. Still had a typo (an extra parenthesis) in my copy buffer when
I
pasted it into the message box. Try this:

=IIf((([PeriodLastAnnointed]>2) And ([Baptised])),"Yes","No")


HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.


:

I tried as you suggested but got the following return:
#Name?

Problem remains. Help still needed. Thx.

:

Hi.

I have a Yes/No field named Baptised. I want this field to be
additional
factor for DueForAnnoitment field so that 2 yes answers are
required to
return YES.

Try:

=IIf(([PeriodLastAnnointed]>2) And ([Baptised]=True),"Yes","No")


HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a
message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are [email protected] and
[email protected]

- - -
When you see correct answers to your question posted in Microsoft's
Online
Community, please sign in to the Community and mark these posts as
"Answers,"
so that all may benefit by filtering on "Answered questions" and
quickly
finding the right answers to similar questions. Remember that
questions
answered the quickest are often from those who have a history of
rewarding
the contributors who have taken the time to answer questions
correctly.


:

I used the following statement in my form to return a Yes or No
to a field
named DueForAnnoitment
=IIf(([PeriodLastAnnoited]>2),"Yes","No") It work quite alright.

My Objective:
I have a Yes/No field named Baptised. I want this field to be
additional
factor for DueForAnnoitment field so that 2 yes answers are
required to
return YES.

I tried the following as the Contgrol Source for DueForAnnoitment
field.
=IIf(([PeriodLastAnnoited]>2),"Yes","No") And
(([Baptised]=Yes),"Yes","No")
It returns negative # ie -1 instead of Yes or No

Your help wiil be appreciated!
Click to expand...
Click to expand...
Click to expand...
 
Top