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
 

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

QUERY 5
Expression Builder; embedded data from other reports in Summary re 3
IF(AND(Complex Formula in Error in data import before I process it 8
Problem with If.... Then.... Else.... Statement 7
Tricky report requirement - “Record Header†that prints once. 2
Value if no date 4
Query based Report in Access using VBA 3
Formula issues 2

Back
Top