Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

[NCLAT2]="M##"AND[NPP1FIN]
Im putting this formula in a report field formatting expression.
The part that is failing is "m##"
That field consists of numbers and letters, but it always starts with M.
Eg. M16 M04 MSW
iVE TRIED M?? AND M**. It still failed, but if I put in M16, the M16 field
would be flaged .
Sure would appreciate help.
Thanks
ed
 
I don't understand your expression... but... I'll try to figure out what
you're doing here.
I think you need...
[NCLAT2] Like "M" & "*" AND [NCLAT2] = [NPP1FIN]
hth
Al Camp
 
Back
Top