if then else statements....HELP!

[mwhalen]

does anyone know why this will not work? I keep getting all renewcontracts.contractnum

If 0=StrCmp({_OrdContracts.ContractNum}, {_RenewContracts.ContractNum}, 0) Then
If 0<>StrCmp({_OrdContracts.ContractNum}, {_RenewContracts.ContractNum}, 0) Then
{_OrdContracts.ContractNum}
Else
{_RenewContracts.ContractNum}
Else
{_RenewContracts.ContractNum}

 

[kenhamady]

This is the net effect of your formula:

If 0=StrCmp({C}, {R}, 0) and 0<>StrCmp({C}, {R}, 0)
Then {C}
Else {R}

The first two conditions have to be true to get the first THEN, so they force you to one of the two ELSE statements.

What are you trying to do? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal