how to use IIf statement

G

Guest

Hi All,

Under the Properties>>>Control Source for field Test under table 2
this is what I have given

=IIf([table1]![field5] Like [field4],"OK","CHECK")

What I need is that it should check if both fiedd from Table 2 and Table1 is
= if yes should allow me to continue or stop and allow me only to enter the
notes

Appreciate if anyone gives me the solution

Thanks
 
S

Steve Schapel

Gerald,

I think for anyone to give specific help, they would need to know the
relationship between Table1 and Table2, and some more information about
field4 and field5 would also be good. Examples would help, as would
more meaningful names for the tables and fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

JOIN issue: Valid Syntax to refer to (In FROM clause) the Selected Fields from Query 15
IIF statement question 4
IIf Statement 2
iif statement 5
IIF Statement in query 5
Query problems with Count(IIF( ...&....)) 2
Data Entry Form/Subform? 2
Combining Fields in a Query into Two Fields 3

Top