Criteria for 'Pairs'

[D]

Hi:

Can you please tell me how do I do the following:

I have a text field [dealno]; the maximum lenght for it is 9.
ieEALNO Pair Matured Leg 1
FX05875 P Yes
FX05876 P Yes
FX05877A Yes
FX05878B Yes
FX05879 P Yes
FX05879X P Yes L 1

The ones that are the same until X are 'pairs' and have P in Pair field; How
do I get not P for the others??
On the same note how do put L 2 in Leg field for the on with no X??

Below is my criteria that does not work 100%:

Pair: IIf(Right([dealno],1)="X","P",IIf(Mid([dealno],8,1) Not In
("A","B","X",Not Null),IIf(Left([dealno],8)<>"FX????X?","P")))

/****

Leg 1: IIf(Right([dealno],1)="X","L 1")

THANKS A LOT!!!

Dan

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can't use Not Null for a column value, it means you don't want NULL,
but you don't state what you want in place of NULL! Therefore, this is
meaningless. What you want is just NULL (according to your example
data).
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBR5f0ZIechKqOuFEgEQL5dgCg3g/642WN6AH0HomDH8/1ZWP6mlMAn2iP
raxBY7ommXb+ZnWmb48Ve2ha
=4QKS
-----END PGP SIGNATURE-----