I have a database that, when created, someone made one of the fields by concatinating two fields from anotehr table as it was imported into Access 97. Now someone else needs one of the columns to be data from the right field 'before' the concatination. Is there a way to say exclude the left three characters for this field in the report?
Exclude the left 3 Characters
- Thread starter rschultz
- Start date
I tried =Mid([Ticket],3) but I got a; 'Syntax error (comma) in query expression' error. When I created the report I chose 'Ticket by 3 Initial Letters' option for my Grouping. I looked at that and it has; '=Left$([Ticket],3)' in the Control Source property. So I tried; '=Mid([Ticket],3)'in the Ticket field in the Details section but then I get #Error AND I get the same thing up in the Group heading field. Weird huh?
Similar threads
