John
The first piece: Left([MyField],instr([MyField],"/"))
Second piece: Mid([MyField],instr([MyField],"/")+1)
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "jfakes.rm" <jfakes@...> wrote:
>
> I have a feild that a user now wants to split into two different fields in a report. I don't have the option of using two different fields in a table as it is one field.
>
> For example 12345/67899 needs to look like:
> 12345/
> 67899
>
> The lengths of the fields can vary for example I could have 1/3, or 12/123, or 1/ (yes thats a blank or null), and there might not be anything in the field at all.
>
> In a query, how can I code a hard return after the "/", taking into account that there might not be a fraction (null) in the field.
>
> Thanks in advance,
> John F
>
Tidak ada komentar:
Posting Komentar