I'm using the following expression to trim text preceeding "TECH REC" in a Text field:
Left([ALERTtxt]![Description],InStr([ALERTtxt]![Description],"TECH REC")-1)
I'd like to use this field with Totals selected - Group By, First, etc. but I get errors with each. If I use Expression it says it's not part of an aggregate function. With Group By, First, etc. it says Invalid Procedure Call.
Could someone help me out with this?
Thanks!
Mike
Left([ALERTtxt]![Description],InStr([ALERTtxt]![Description],"TECH REC")-1)
I'd like to use this field with Totals selected - Group By, First, etc. but I get errors with each. If I use Expression it says it's not part of an aggregate function. With Group By, First, etc. it says Invalid Procedure Call.
Could someone help me out with this?
Thanks!
Mike