Find and delete asterisk from name field

[pgruenke]

My database captures information regarding juveniles. You can have on rare occasions more than one juvenile with the same ID (ID made up of a combination of county, last name, first name and BD). If you do have a juvenile who will have the same ID as another, the user enters an asterisk as the second character of the first name field. Fine for keeping juvenile records straight, not so good when generating a report for court.

In the report I have a field named "Last_Name" which holds a concatenation of the first, middle and last names. I don't want to get rid of the asterisk in the juvenile info table, but I don't want it to appear in the report. The asterisk would be present in a minimal number of records. What does it take for the asterisk not to appear on the report. Thanks Pat

[CJ_London]

in your report recordsource use

replace(Last_Name,"*","")

[pgruenke]

When you say report recordsource, do you mean in the query that I created for the report? If so, where? Or would it go in the SQL?

[pgruenke]

I have it. Thanks

[pgruenke]

Ajax, it didn't work. I tried it with "*" and Chr(42). The asterisk doesn't disappear. What am I doing wrong?

[Micron]

Post the sql attempts you made.

[pgruenke]

Finally got it correct. Something so obvious after it dawned on me. User error. Thanks