Stan, did you get this worked out?

I'm not positive what you are looking for, but you seem to have the first part okay.

You would create a formula that would "trim" the first part of the part number field, making a new "CalPart" field.

Then you use the newly created calculation field "CalPart" to list the numbers. For this to work correctly you might have to convert you new field "CalPart" into numeric format then sort/use it. Because Part number is an Alpha numeric field.

Hope this helps.

Nancy

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of stanchmura

Sent: Monday, April 18, 2011 4:46 PM

To: vantage@yahoogroups.com

Subject: [Vantage] Report Builder Function

Hi: I am using Vantage 6.1 and Progress Report Builder. I am trying to find a sequence of part numbers added to the part master after a certain sequential number. However all our numbers have a 5 letter prefix that varies followed by 6 digit numeric. e.g.FTIMG22232. So I weant a list that would like like FTIMG22232, FTICR22233, FTIBL22234, etc. I think the function from report builder: LEFT-TRIM(char,opt char) would remove the first 5 letters. That would produce a new field that would turn "FTIMG22232" into just "22232" etc. Then the greater than Boolean would produce the needed list. I don't know how to configure the formula. Can anyone help?

Thanks!

Stan

[Non-text portions of this message have been removed]

I'm not positive what you are looking for, but you seem to have the first part okay.

You would create a formula that would "trim" the first part of the part number field, making a new "CalPart" field.

Then you use the newly created calculation field "CalPart" to list the numbers. For this to work correctly you might have to convert you new field "CalPart" into numeric format then sort/use it. Because Part number is an Alpha numeric field.

Hope this helps.

Nancy

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of stanchmura

Sent: Monday, April 18, 2011 4:46 PM

To: vantage@yahoogroups.com

Subject: [Vantage] Report Builder Function

Hi: I am using Vantage 6.1 and Progress Report Builder. I am trying to find a sequence of part numbers added to the part master after a certain sequential number. However all our numbers have a 5 letter prefix that varies followed by 6 digit numeric. e.g.FTIMG22232. So I weant a list that would like like FTIMG22232, FTICR22233, FTIBL22234, etc. I think the function from report builder: LEFT-TRIM(char,opt char) would remove the first 5 letters. That would produce a new field that would turn "FTIMG22232" into just "22232" etc. Then the greater than Boolean would produce the needed list. I don't know how to configure the formula. Can anyone help?

Thanks!

Stan

[Non-text portions of this message have been removed]