Question Iff statement

[Joe8915]

Contains 2 fields
chkbx6
InvoiceNumber

I have a chkbx, I need to have it check when another field contains final.
In my querry this is what I have so far:

Def6: IIf([InvoiceNumber]<>"final","check")

As you can see this works to make it read check.

But how do I make the chkbx to be check?

 

[jdraw]

Def6: IIf([InvoiceNumber]<>"final","check")

As you can see this works to make it read check.

But how do I make the chkbx to be check?

An IIF statement has 3 parts

a condition
[InvoiceNumber]<>"final"
a value if the condition is True, and
a value if the condition is False

You do not have the correct syntax -- you are missing the Value for a False condition.
see http://www.techonthenet.com/access/functions/advanced/iif.php

However, I'm not sure I understand this

But how do I make the chkbx to be check

 

[Trevor G]

Contains 2 fields
chkbx6
InvoiceNumber

I have a chkbx, I need to have it check when another field contains final.
In my querry this is what I have so far:

Def6: IIf([InvoiceNumber]<>"final","check")

As you can see this works to make it read check.

But how do I make the chkbx to be check?

Not in a Select Query but you could do this as an Update Query.

 

[Joe8915]

jdraw, thanks for the quick reply. I need the check box showing its "check".

If the invoicenumber field contains final, make chkbx6 shows a check mark