(Left) expression in a query

  • Thread starter Thread starter CAJ
  • Start date Start date
C

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?
 
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.
 
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.


CAJ said:
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?
Click to expand...


.
Click to expand...
 
Back
Top