Part of Feild

[Majid Umar]

Hi,

In Query I'm trying to output Tenant No using using following criteria:

Left ([Tenant_No],6)

In order to output last 6 digits of Tenant No. But I'm getting no records at all.

Any Suggestion ???

 

[Jack Cowley]

In a new Column in the QBE grid put: Tenant No.: Left([Tenant_No],6)

This will give you FIRST 6 characters of the Tenant_No string.... If you want the last 6 characters of the string use the Right function.