Field Truncation

[Jesse_Munos]

So I am building a query that pulls data from 7 tables. One field in this query is giving me issues and I think the easiest way to resolve it is to change the way the table stores one of its fields.



Essentially I have a table that is organized by computer names in the following format style

w7-x1d45jc.companyname.local

This data refuses to aggregate with all of the other tables because none of those tables have the .compayname.local as part of their computer name fields.

How do I go about truncating this data or querying on everything before the period?

[June7]

What do you mean by 'aggregate with all of the other tables'? Exactly what are you trying to do?

Use string manipulation functions in expression to create a field in query that extracts the string part you need.

Left(fieldname, InStr(fieldname,".")-1)