combining data for grouping levels

Paulp

New member
Local time
Today, 20:23
Joined
Dec 6, 1999
Messages
5
A97 - I am currently grouping my report by a field named "project Number". The project numbers entered into the table consist of the actual project number and the revision, for example 1234-987 would be project 1234 rev 987. Can I have the report look at only the first 4 characters of this field so that I can group all of project 1234 reguardless of rev.? Thanks
Paul
 

Users who are viewing this thread

Back
Top Bottom