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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

=Left([FieldName],5)
=Mid([FieldName],6,5)
 
Thank you. It worked :)

KARL DEWEY said:
Try this --
Left([field_name],5)
and
Right(Left([field_name],10),5)

--
KARL DEWEY
Build a little - Test a little


Glova said:
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
Click to expand...
Click to expand...
 
Back
Top