How can I place partial data from a field in a report?

[Guest]

I am working with an acess database linked to another database through an
ODBC. There is a field in the linked table that contains several pieces of
information. I need to display the the first 5 characters in one part of the
report, and characters 6-10 in another. I tried =field_name (1,5) but I seem
to be missing something.
Thanks

 

[Guest]

Try this --
Left([field_name],5)
and
Right(Left([field_name],10),5)

 

[fredg]

I am working with an acess database linked to another database through an
ODBC. There is a field in the linked table that contains several pieces of
information. I need to display the the first 5 characters in one part of the
report, and characters 6-10 in another. I tried =field_name (1,5) but I seem
to be missing something.
Thanks

=Left([FieldName],5)
=Mid([FieldName],6,5)

 

[Guest]

Thank you. It worked

Try this --
Left([field_name],5)
and
Right(Left([field_name],10),5)

--
KARL DEWEY
Build a little - Test a little

I am working with an acess database linked to another database through an
ODBC. There is a field in the linked table that contains several pieces of
information. I need to display the the first 5 characters in one part of the
report, and characters 6-10 in another. I tried =field_name (1,5) but I seem
to be missing something.
Thanks