I have two fields, one is the customer code and the other is the product
code. Both fields are text fields with a field size of 12. The data in the
fields have leading spaces with data values from 1 to 999999 so there are
from 11 to six leading spaces. How do I format the fields on a query or
report to display the values without the leading spaces?

Thanks,

Scott

Use the Trim function:

SELECT Trim(Field1) From MyTable

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Scott" <(E-Mail Removed)> wrote in message
news:6E9FE3DA-7F5C-4D4E-AF15-(E-Mail Removed)...
>I have two fields, one is the customer code and the other is the product
> code. Both fields are text fields with a field size of 12. The data in
> the
> fields have leading spaces with data values from 1 to 999999 so there are
> from 11 to six leading spaces. How do I format the fields on a query or
> report to display the values without the leading spaces?
>
> Thanks,
>
> Scott

Scott,

Use the trim() function.

SELECT
Trim(your_field_with_the_spaces)
FROM
you_table

Cheers,
Jason Lepack

On Jun 1, 4:27 pm, Scott <S...@discussions.microsoft.com> wrote:
> I have two fields, one is the customer code and the other is the product
> code. Both fields are text fields with a field size of 12. The data in the
> fields have leading spaces with data values from 1 to 999999 so there are
> from 11 to six leading spaces. How do I format the fields on a query or
> report to display the values without the leading spaces?
>
> Thanks,
>
> Scott

Worked great! Thank you -

"Douglas J. Steele" wrote:

> Use the Trim function:
>
> SELECT Trim(Field1) From MyTable
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Scott" <(E-Mail Removed)> wrote in message
> news:6E9FE3DA-7F5C-4D4E-AF15-(E-Mail Removed)...
> >I have two fields, one is the customer code and the other is the product
> > code. Both fields are text fields with a field size of 12. The data in
> > the
> > fields have leading spaces with data values from 1 to 999999 so there are
> > from 11 to six leading spaces. How do I format the fields on a query or
> > report to display the values without the leading spaces?
> >
> > Thanks,
> >
> > Scott
>
>
>

Thank you!

"Jason Lepack" wrote:

> Scott,
>
> Use the trim() function.
>
> SELECT
> Trim(your_field_with_the_spaces)
> FROM
> you_table
>
> Cheers,
> Jason Lepack
>
> On Jun 1, 4:27 pm, Scott <S...@discussions.microsoft.com> wrote:
> > I have two fields, one is the customer code and the other is the product
> > code. Both fields are text fields with a field size of 12. The data in the
> > fields have leading spaces with data values from 1 to 999999 so there are
> > from 11 to six leading spaces. How do I format the fields on a query or
> > report to display the values without the leading spaces?
> >
> > Thanks,
> >
> > Scott
>
>
>