(Left) expression in a query

[CAJ]

I have a field that has 7 characters in it (both numeric
and alpha ) I want to pull all the records but only what
to show the first 5 characters. used the left expression:
Left([field name],5)
and it only pulls back records with 5 characters. any help
on how to do this?

 

[Fredg]

Where are you placing the Left([FieldName],5) expression?
As criteria?

If you wish to show all the records then you need to add a new column to the
query:
NewField:Left([FieldName],5)

Do NOT use any criteria on this field.

The first 5 characters of the [FieldName] field in every record will be
returned.

 

[CAJ]

THANKS A BUNCH.. ABLE TO WORK IT OUT..

-----Original Message-----
Where are you placing the Left([FieldName],5) expression?
As criteria?

If you wish to show all the records then you need to add a new column to the
query:
NewField:Left([FieldName],5)

Do NOT use any criteria on this field.

The first 5 characters of the [FieldName] field in every record will be
returned.


--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

I have a field that has 7 characters in it (both numeric
and alpha ) I want to pull all the records but only what
to show the first 5 characters. used the left expression:
Left([field name],5)
and it only pulls back records with 5 characters. any help
on how to do this?

.