Thanks Clive,
I don't know much about programming and I couldn't figure it out. I wasn't aware I could use the & to join the secondpart.
John
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> Hi John,
>
> I just tested the query and discovered that the
> Constant, vbCrLf, is not recognized in the query field.
>
> Instead you will need to use,
>
> ColumnName: FirstPart & Chr$(13) & Chr$(10) & SecondPart
>
> Sorry for not checking it the first time.
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@> wrote:
> >
> > Hi John,
> >
> > I think Bill was expecting you to work it out <g>.
> >
> > If you are doing it a query, which is what I would
> > expect, then you need:
> >
> > ColumnName: FirstPart & vbcrlf & SecondPart.
> >
> > Or use the Function from my previous post.
> >
> > Regards, Clive.
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "jfakes.rm" <jfakes@> wrote:
> > >
> > > Bill, thanks for sending this. Is there a way to put it one field instead of two?
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> > > >
> > > > 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