LaborDtl VBForm

Yahoo Archive
1
Hi Aaron, Sarah and everyone else,

I am interested as well.
Labor reporting through data collection is where its at. (cost wise)

Thank You,

John Mansfield
General Sheet Metal
2
I am writing a report using report builder (still on v6.1) using the
Labor Note field. We record the number of operators/job using this
field, but also included the word operator(s). I have since asked
that only a number be included in this field, but I need to get
historical data using this field, so need to convert it to a numeric.

My challenge is parsing out the word operator or operators, getting to
the only the number and then converting to numeric(2.5 operators - for
instance), so I can do calculations with this field. Is it possible
to perform these functions?

Mark Smith
3
This is a little klutzy so there might be a better way but...
First run the LaborNote through an aggregate function (like Maximum and call it something else like MaxLaborNote) because it is a Memo type field and RB chokes on them. Running through an aggregate gets around that.
Then a function field like....
NUMERIC(TRIM(REPLACE(REPLACE(MaxLaborNote,'Operator',''),'s','')))

...and I think this would only work if this is ALL that is in the note field though. If there is other text you might need to do something like a SUBSTRING function on the INDEX position of "Oper" minus some number of characters - the fly in the ointment is the variable nature of the operator numbers (2,2.5,3, etc...) so it gets trickier to find the start and end of the actual number. But I'm sure it could be done...like assume all integers are only one digit and all decimal numbers are 3 (with the decimal point) and have two fuctions...one for if there is a "." prior to the "oper" characters and another if there is no "."

Anyway, the above might offer some starting places.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of innerpac_il
Sent: Friday, February 10, 2006 11:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Labor Note


I am writing a report using report builder (still on v6.1) using the
Labor Note field. We record the number of operators/job using this
field, but also included the word operator(s). I have since asked
that only a number be included in this field, but I need to get
historical data using this field, so need to convert it to a numeric.

My challenge is parsing out the word operator or operators, getting to
the only the number and then converting to numeric(2.5 operators - for
instance), so I can do calculations with this field. Is it possible
to perform these functions?

Mark Smith






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]
4
Looking at it form another direction, could a vb field be used?



--- In vantage@yahoogroups.com, "innerpac_il" <mark_smith@...> wrote:
>
> I am writing a report using report builder (still on v6.1) using the
> Labor Note field. We record the number of operators/job using this
> field, but also included the word operator(s). I have since asked
> that only a number be included in this field, but I need to get
> historical data using this field, so need to convert it to a numeric.
>
> My challenge is parsing out the word operator or operators, getting
to
> the only the number and then converting to numeric(2.5 operators -
for
> instance), so I can do calculations with this field. Is it possible
> to perform these functions?
>
> Mark Smith
>
5
Yes, definitely going forward, but am trying to get at historical data.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of brychanwilliams
Sent: Friday, February 10, 2006 11:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Labor Note



Looking at it form another direction, could a vb field be used?



--- In vantage@yahoogroups.com, "innerpac_il" <mark_smith@...> wrote:
>
> I am writing a report using report builder (still on v6.1) using the
> Labor Note field. We record the number of operators/job using this
> field, but also included the word operator(s). I have since asked
> that only a number be included in this field, but I need to get
> historical data using this field, so need to convert it to a numeric.
>
> My challenge is parsing out the word operator or operators, getting
to
> the only the number and then converting to numeric(2.5 operators -
for
> instance), so I can do calculations with this field. Is it possible
> to perform these functions?
>
> Mark Smith
>






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



________________________________



[Non-text portions of this message have been removed]
6
Ah, this brings up a MAJOR frustration I have of late.
Am I the only one that wants to give Operators access to a VBForm to enter
additional information as required?
We use Data Collection, and I am more than a little annoyed that I can't get
at that screen from ShopFloor. I am even more frustrated that, contrary to
a personal promise made during Beta testing of V8, I understand that V8
still has no customization for ShopFloor and therefore also has no access to
those fields.
Anyone else as annoyed?
Aaron Hoyt
Vantage Plastics


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of brychanwilliams
Sent: Friday, February 10, 2006 12:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Labor Note


Looking at it form another direction, could a vb field be used?



--- In vantage@yahoogroups.com, "innerpac_il" <mark_smith@...> wrote:
>
> I am writing a report using report builder (still on v6.1) using the
> Labor Note field. We record the number of operators/job using this
> field, but also included the word operator(s). I have since asked
> that only a number be included in this field, but I need to get
> historical data using this field, so need to convert it to a numeric.
>
> My challenge is parsing out the word operator or operators, getting
to
> the only the number and then converting to numeric(2.5 operators -
for
> instance), so I can do calculations with this field. Is it possible
> to perform these functions?
>
> Mark Smith
>
7
Yes, that would benefit us also. Is there a change request # you created
that we can ourselves to?
8
Todd I have two different scenarios using a SubString, but I can't
figure out how to ignore characters after the decimal point it not
an interger.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@...> wrote:
>
> This is a little klutzy so there might be a better way but...
> First run the LaborNote through an aggregate function (like
Maximum and call it something else like MaxLaborNote) because it is
a Memo type field and RB chokes on them. Running through an
aggregate gets around that.
> Then a function field like....
> NUMERIC(TRIM(REPLACE(REPLACE(MaxLaborNote,'Operator',''),'s','')))
>
> ...and I think this would only work if this is ALL that is in the
note field though. If there is other text you might need to do
something like a SUBSTRING function on the INDEX position of "Oper"
minus some number of characters - the fly in the ointment is the
variable nature of the operator numbers (2,2.5,3, etc...) so it gets
trickier to find the start and end of the actual number. But I'm
sure it could be done...like assume all integers are only one digit
and all decimal numbers are 3 (with the decimal point) and have two
fuctions...one for if there is a "." prior to the "oper" characters
and another if there is no "."
>
> Anyway, the above might offer some starting places.
> -Todd C.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of innerpac_il
> Sent: Friday, February 10, 2006 11:00 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] RE: Labor Note
>
>
> I am writing a report using report builder (still on v6.1) using
the
> Labor Note field. We record the number of operators/job using
this
> field, but also included the word operator(s). I have since asked
> that only a number be included in this field, but I need to get
> historical data using this field, so need to convert it to a
numeric.
>
> My challenge is parsing out the word operator or operators,
getting to
> the only the number and then converting to numeric(2.5 operators -
for
> instance), so I can do calculations with this field. Is it
possible
> to perform these functions?
>
> Mark Smith
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
>
>
>
> SPONSORED LINKS
> Manufacturing <http://groups.yahoo.com/gads?
t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership
+database+software&w3=Database+mortgage+software&w4=Pda+database+soft
ware&w5=Database+management+software&w6=Database+marketing+software&c
=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
<http://groups.yahoo.com/gads?
t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Memb
ership+database+software&w3=Database+mortgage+software&w4=Pda+databas
e+software&w5=Database+management+software&w6=Database+marketing+soft
ware&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database <http://groups.yahoo.com/gads?
t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Member
ship+database+software&w3=Database+mortgage+software&w4=Pda+database+
software&w5=Database+management+software&w6=Database+marketing+softwa
re&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
> Pda <http://groups.yahoo.com/gads?
t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+
database+software&w3=Database+mortgage+software&w4=Pda+database+softw
are&w5=Database+management+software&w6=Database+marketing+software&c=
6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database
<http://groups.yahoo.com/gads?
t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Memb
ership+database+software&w3=Database+mortgage+software&w4=Pda+databas
e+software&w5=Database+management+software&w6=Database+marketing+soft
ware&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database <http://groups.yahoo.com/gads?
t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membe
rship+database+software&w3=Database+mortgage+software&w4=Pda+database
+software&w5=Database+management+software&w6=Database+marketing+softw
are&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group " vantage
<http://groups.yahoo.com/group/vantage> " on the web.
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com <mailto:vantage-
unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
>
>
> _____
>
>
>
>
> [Non-text portions of this message have been removed]
>
9
Perhaps post a couple examples because I am not real clear what you mean.

When it is not an integer (say perhaps 3.5) are you getting other character beyond the 5 or is it the .5 you want to ignore? If it is just spaces trailing at the end (like "3.5 ") you could use the Right-Trim function before converting the string to numeric. For controling things like the exact locations in the substring function the INDEX fucntion is pretty good for identifying the location of the decimal point.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of innerpac_il
Sent: Friday, February 10, 2006 2:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Labor Note


Todd I have two different scenarios using a SubString, but I can't
figure out how to ignore characters after the decimal point it not
an interger.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@...> wrote:
>
> This is a little klutzy so there might be a better way but...
> First run the LaborNote through an aggregate function (like
Maximum and call it something else like MaxLaborNote) because it is
a Memo type field and RB chokes on them. Running through an
aggregate gets around that.
> Then a function field like....
> NUMERIC(TRIM(REPLACE(REPLACE(MaxLaborNote,'Operator',''),'s','')))
>
> ...and I think this would only work if this is ALL that is in the
note field though. If there is other text you might need to do
something like a SUBSTRING function on the INDEX position of "Oper"
minus some number of characters - the fly in the ointment is the
variable nature of the operator numbers (2,2.5,3, etc...) so it gets
trickier to find the start and end of the actual number. But I'm
sure it could be done...like assume all integers are only one digit
and all decimal numbers are 3 (with the decimal point) and have two
fuctions...one for if there is a "." prior to the "oper" characters
and another if there is no "."
>
> Anyway, the above might offer some starting places.
> -Todd C.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of innerpac_il
> Sent: Friday, February 10, 2006 11:00 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] RE: Labor Note
>
>
> I am writing a report using report builder (still on v6.1) using
the
> Labor Note field. We record the number of operators/job using
this
> field, but also included the word operator(s). I have since asked
> that only a number be included in this field, but I need to get
> historical data using this field, so need to convert it to a
numeric.
>
> My challenge is parsing out the word operator or operators,
getting to
> the only the number and then converting to numeric(2.5 operators -
for
> instance), so I can do calculations with this field. Is it
possible
> to perform these functions?
>
> Mark Smith
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
>
>
>
> SPONSORED LINKS
> Manufacturing < http://groups.yahoo.com/gads?
t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership
+database+software&w3=Database+mortgage+software&w4=Pda+database+soft
ware&w5=Database+management+software&w6=Database+marketing+software&c
=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
< http://groups.yahoo.com/gads?
t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Memb
ership+database+software&w3=Database+mortgage+software&w4=Pda+databas
e+software&w5=Database+management+software&w6=Database+marketing+soft
ware&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database < http://groups.yahoo.com/gads?
t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Member
ship+database+software&w3=Database+mortgage+software&w4=Pda+database+
software&w5=Database+management+software&w6=Database+marketing+softwa
re&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
> Pda < http://groups.yahoo.com/gads?
t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+
database+software&w3=Database+mortgage+software&w4=Pda+database+softw
are&w5=Database+management+software&w6=Database+marketing+software&c=
6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database
< http://groups.yahoo.com/gads?
t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Memb
ership+database+software&w3=Database+mortgage+software&w4=Pda+databas
e+software&w5=Database+management+software&w6=Database+marketing+soft
ware&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database < http://groups.yahoo.com/gads?
t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membe
rship+database+software&w3=Database+mortgage+software&w4=Pda+database
+software&w5=Database+management+software&w6=Database+marketing+softw
are&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group " vantage
< http://groups.yahoo.com/group/vantage> " on the web.
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com <mailto:vantage-
unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/> .
>
>
> _____
>
>
>
>
> [Non-text portions of this message have been removed]
>







Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]
10
Yes for example, when the number of operators is entered as a whole
number everything after 'position' 1 is the oper...., so I want to
ignore everything but the integer. I am getting confused as I begin to
encapsulate functions. Does the above make sense?



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Friday, February 10, 2006 3:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Labor Note



Perhaps post a couple examples because I am not real clear what you
mean.

When it is not an integer (say perhaps 3.5) are you getting other
character beyond the 5 or is it the .5 you want to ignore? If it is
just spaces trailing at the end (like "3.5 ") you could use the
Right-Trim function before converting the string to numeric. For
controling things like the exact locations in the substring function the
INDEX fucntion is pretty good for identifying the location of the
decimal point.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of innerpac_il
Sent: Friday, February 10, 2006 2:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Labor Note


Todd I have two different scenarios using a SubString, but I can't
figure out how to ignore characters after the decimal point it not
an interger.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@...> wrote:
>
> This is a little klutzy so there might be a better way but...
> First run the LaborNote through an aggregate function (like
Maximum and call it something else like MaxLaborNote) because it is
a Memo type field and RB chokes on them. Running through an
aggregate gets around that.
> Then a function field like....
> NUMERIC(TRIM(REPLACE(REPLACE(MaxLaborNote,'Operator',''),'s','')))
>
> ...and I think this would only work if this is ALL that is in the
note field though. If there is other text you might need to do
something like a SUBSTRING function on the INDEX position of "Oper"
minus some number of characters - the fly in the ointment is the
variable nature of the operator numbers (2,2.5,3, etc...) so it gets
trickier to find the start and end of the actual number. But I'm
sure it could be done...like assume all integers are only one digit
and all decimal numbers are 3 (with the decimal point) and have two
fuctions...one for if there is a "." prior to the "oper" characters
and another if there is no "."
>
> Anyway, the above might offer some starting places.
> -Todd C.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of innerpac_il
> Sent: Friday, February 10, 2006 11:00 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] RE: Labor Note
>
>
> I am writing a report using report builder (still on v6.1) using
the
> Labor Note field. We record the number of operators/job using
this
> field, but also included the word operator(s). I have since asked
> that only a number be included in this field, but I need to get
> historical data using this field, so need to convert it to a
numeric.
>
> My challenge is parsing out the word operator or operators,
getting to
> the only the number and then converting to numeric(2.5 operators -
for
> instance), so I can do calculations with this field. Is it
possible
> to perform these functions?
>
> Mark Smith
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
>
>
>
> SPONSORED LINKS
> Manufacturing < http://groups.yahoo.com/gads?
t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership
+database+software&w3=Database+mortgage+software&w4=Pda+database+soft
ware&w5=Database+management+software&w6=Database+marketing+software&c
=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
< http://groups.yahoo.com/gads?
t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Memb
ership+database+software&w3=Database+mortgage+software&w4=Pda+databas
e+software&w5=Database+management+software&w6=Database+marketing+soft
ware&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database < http://groups.yahoo.com/gads?
t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Member
ship+database+software&w3=Database+mortgage+software&w4=Pda+database+
software&w5=Database+management+software&w6=Database+marketing+softwa
re&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
> Pda < http://groups.yahoo.com/gads?
t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+
database+software&w3=Database+mortgage+software&w4=Pda+database+softw
are&w5=Database+management+software&w6=Database+marketing+software&c=
6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database
< http://groups.yahoo.com/gads?
t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Memb
ership+database+software&w3=Database+mortgage+software&w4=Pda+databas
e+software&w5=Database+management+software&w6=Database+marketing+soft
ware&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database < http://groups.yahoo.com/gads?
t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membe
rship+database+software&w3=Database+mortgage+software&w4=Pda+database
+software&w5=Database+management+software&w6=Database+marketing+softw
are&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group " vantage
< http://groups.yahoo.com/group/vantage> " on the web.
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com <mailto:vantage-
unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/> .
>
>
> _____
>
>
>
>
> [Non-text portions of this message have been removed]
>







Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS
Manufacturing
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software
Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
database software Database
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage
software
Pda
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database
software Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
management software Database
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage
<http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


_____




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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



________________________________



[Non-text portions of this message have been removed]
11
IIF(INDEX(MaxLaborNote,'.') > 0,
NUMERIC(SUBSTRING(MaxLaborNote,INDEX(MaxLaborNote,'.') - 1,3)),
NUMERIC(SUBSTRING(MaxLaborNote,INDEX(MaxLaborNote,'Oper') - 2,1)))

Try the above (assuming the result of the aggregate was MaxLaborNote). If there is a decimal point in the string then it will take the 3 characters starting at one position left of that point. Otherwise it will look for "Oper" and count back 2 positions and use that one character (the integer).

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Mark Smith
Sent: Friday, February 10, 2006 3:46 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Labor Note


Yes for example, when the number of operators is entered as a whole
number everything after 'position' 1 is the oper...., so I want to
ignore everything but the integer. I am getting confused as I begin to
encapsulate functions. Does the above make sense?



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Friday, February 10, 2006 3:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Labor Note



Perhaps post a couple examples because I am not real clear what you
mean.

When it is not an integer (say perhaps 3.5) are you getting other
character beyond the 5 or is it the .5 you want to ignore? If it is
just spaces trailing at the end (like "3.5 ") you could use the
Right-Trim function before converting the string to numeric. For
controling things like the exact locations in the substring function the
INDEX fucntion is pretty good for identifying the location of the
decimal point.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of innerpac_il
Sent: Friday, February 10, 2006 2:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Labor Note


Todd I have two different scenarios using a SubString, but I can't
figure out how to ignore characters after the decimal point it not
an interger.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@...> wrote:
>
> This is a little klutzy so there might be a better way but...
> First run the LaborNote through an aggregate function (like
Maximum and call it something else like MaxLaborNote) because it is
a Memo type field and RB chokes on them. Running through an
aggregate gets around that.
> Then a function field like....
> NUMERIC(TRIM(REPLACE(REPLACE(MaxLaborNote,'Operator',''),'s','')))
>
> ...and I think this would only work if this is ALL that is in the
note field though. If there is other text you might need to do
something like a SUBSTRING function on the INDEX position of "Oper"
minus some number of characters - the fly in the ointment is the
variable nature of the operator numbers (2,2.5,3, etc...) so it gets
trickier to find the start and end of the actual number. But I'm
sure it could be done...like assume all integers are only one digit
and all decimal numbers are 3 (with the decimal point) and have two
fuctions...one for if there is a "." prior to the "oper" characters
and another if there is no "."
>
> Anyway, the above might offer some starting places.
> -Todd C.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of innerpac_il
> Sent: Friday, February 10, 2006 11:00 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] RE: Labor Note
>
>
> I am writing a report using report builder (still on v6.1) using
the
> Labor Note field. We record the number of operators/job using
this
> field, but also included the word operator(s). I have since asked
> that only a number be included in this field, but I need to get
> historical data using this field, so need to convert it to a
numeric.
>
> My challenge is parsing out the word operator or operators,
getting to
> the only the number and then converting to numeric(2.5 operators -
for
> instance), so I can do calculations with this field. Is it
possible
> to perform these functions?
>
> Mark Smith
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
< http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
>
>
>
> SPONSORED LINKS
> Manufacturing < http://groups.yahoo.com/gads?
t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership
+database+software&w3=Database+mortgage+software&w4=Pda+database+soft
ware&w5=Database+management+software&w6=Database+marketing+software&c
=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
< http://groups.yahoo.com/gads?
t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Memb
ership+database+software&w3=Database+mortgage+software&w4=Pda+databas
e+software&w5=Database+management+software&w6=Database+marketing+soft
ware&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database < http://groups.yahoo.com/gads?
t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Member
ship+database+software&w3=Database+mortgage+software&w4=Pda+database+
software&w5=Database+management+software&w6=Database+marketing+softwa
re&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
> Pda < http://groups.yahoo.com/gads?
t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+
database+software&w3=Database+mortgage+software&w4=Pda+database+softw
are&w5=Database+management+software&w6=Database+marketing+software&c=
6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database
< http://groups.yahoo.com/gads?
t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Memb
ership+database+software&w3=Database+mortgage+software&w4=Pda+databas
e+software&w5=Database+management+software&w6=Database+marketing+soft
ware&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database < http://groups.yahoo.com/gads?
t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membe
rship+database+software&w3=Database+mortgage+software&w4=Pda+database
+software&w5=Database+management+software&w6=Database+marketing+softw
are&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group " vantage
< http://groups.yahoo.com/group/vantage> " on the web.
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com <mailto:vantage-
unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/> .
>
>
> _____
>
>
>
>
> [Non-text portions of this message have been removed]
>







Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
< http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS
Manufacturing
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu> &k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software
Membership
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man> &k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
database software Database
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf> &k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage
software
Pda
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur> &k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database
software Database
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man> &k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
management software Database
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu> &k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage
< http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/> .


_____




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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
< http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS

Manufacturing software
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu> &k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man> &k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf> &k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur> &k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man> &k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu> &k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
< http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/> .



________________________________



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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]
12
Sarah, And anyone else that might be interested in this (the more the
merrier),
I submitted a request for this...Turns out it was originally requested by
the Sydney Branch office. The number to attach to is...
54SYD.
I also submitted a separate request for 8.0 and that was given the number...
8972MPS.
My request included adding the VBForm to both End Activity and Report
Quantity (though I think the second half has little chance).
Thanks for supporting the cause,
Aaron Hoyt
Vantage Plastics


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of sarah.vareschi@...
Sent: Friday, February 10, 2006 1:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] LaborDtl VBForm


Yes, that would benefit us also. Is there a change request # you created
that we can ourselves to?


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
13
Todd, thanks very much for your help. The below function is working!



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Friday, February 10, 2006 3:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Labor Note



IIF(INDEX(MaxLaborNote,'.') > 0,
NUMERIC(SUBSTRING(MaxLaborNote,INDEX(MaxLaborNote,'.') - 1,3)),
NUMERIC(SUBSTRING(MaxLaborNote,INDEX(MaxLaborNote,'Oper') - 2,1)))

Try the above (assuming the result of the aggregate was MaxLaborNote).
If there is a decimal point in the string then it will take the 3
characters starting at one position left of that point. Otherwise it
will look for "Oper" and count back 2 positions and use that one
character (the integer).

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Mark Smith
Sent: Friday, February 10, 2006 3:46 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Labor Note


Yes for example, when the number of operators is entered as a whole
number everything after 'position' 1 is the oper...., so I want to
ignore everything but the integer. I am getting confused as I begin to
encapsulate functions. Does the above make sense?



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Friday, February 10, 2006 3:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Labor Note



Perhaps post a couple examples because I am not real clear what you
mean.

When it is not an integer (say perhaps 3.5) are you getting other
character beyond the 5 or is it the .5 you want to ignore? If it is
just spaces trailing at the end (like "3.5 ") you could use the
Right-Trim function before converting the string to numeric. For
controling things like the exact locations in the substring function the
INDEX fucntion is pretty good for identifying the location of the
decimal point.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of innerpac_il
Sent: Friday, February 10, 2006 2:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Labor Note


Todd I have two different scenarios using a SubString, but I can't
figure out how to ignore characters after the decimal point it not
an interger.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@...> wrote:
>
> This is a little klutzy so there might be a better way but...
> First run the LaborNote through an aggregate function (like
Maximum and call it something else like MaxLaborNote) because it is
a Memo type field and RB chokes on them. Running through an
aggregate gets around that.
> Then a function field like....
> NUMERIC(TRIM(REPLACE(REPLACE(MaxLaborNote,'Operator',''),'s','')))
>
> ...and I think this would only work if this is ALL that is in the
note field though. If there is other text you might need to do
something like a SUBSTRING function on the INDEX position of "Oper"
minus some number of characters - the fly in the ointment is the
variable nature of the operator numbers (2,2.5,3, etc...) so it gets
trickier to find the start and end of the actual number. But I'm
sure it could be done...like assume all integers are only one digit
and all decimal numbers are 3 (with the decimal point) and have two
fuctions...one for if there is a "." prior to the "oper" characters
and another if there is no "."
>
> Anyway, the above might offer some starting places.
> -Todd C.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of innerpac_il
> Sent: Friday, February 10, 2006 11:00 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] RE: Labor Note
>
>
> I am writing a report using report builder (still on v6.1) using
the
> Labor Note field. We record the number of operators/job using
this
> field, but also included the word operator(s). I have since asked
> that only a number be included in this field, but I need to get
> historical data using this field, so need to convert it to a
numeric.
>
> My challenge is parsing out the word operator or operators,
getting to
> the only the number and then converting to numeric(2.5 operators -
for
> instance), so I can do calculations with this field. Is it
possible
> to perform these functions?
>
> Mark Smith
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
< http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
>
>
>
> SPONSORED LINKS
> Manufacturing < http://groups.yahoo.com/gads?
t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership
+database+software&w3=Database+mortgage+software&w4=Pda+database+soft
ware&w5=Database+management+software&w6=Database+marketing+software&c
=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
< http://groups.yahoo.com/gads?
t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Memb
ership+database+software&w3=Database+mortgage+software&w4=Pda+databas
e+software&w5=Database+management+software&w6=Database+marketing+soft
ware&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database < http://groups.yahoo.com/gads?
t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Member
ship+database+software&w3=Database+mortgage+software&w4=Pda+database+
software&w5=Database+management+software&w6=Database+marketing+softwa
re&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
> Pda < http://groups.yahoo.com/gads?
t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+
database+software&w3=Database+mortgage+software&w4=Pda+database+softw
are&w5=Database+management+software&w6=Database+marketing+software&c=
6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database
< http://groups.yahoo.com/gads?
t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Memb
ership+database+software&w3=Database+mortgage+software&w4=Pda+databas
e+software&w5=Database+management+software&w6=Database+marketing+soft
ware&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database < http://groups.yahoo.com/gads?
t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membe
rship+database+software&w3=Database+mortgage+software&w4=Pda+database
+software&w5=Database+management+software&w6=Database+marketing+softw
are&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group " vantage
< http://groups.yahoo.com/group/vantage> " on the web.
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com <mailto:vantage-
unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/> .
>
>
> _____
>
>
>
>
> [Non-text portions of this message have been removed]
>







Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
< http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS
Manufacturing
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
> &k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software
Membership
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
> &k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
database software Database
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
> &k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage
software
Pda
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
> &k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database
software Database
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
> &k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
management software Database
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
> &k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage
< http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/> .


_____




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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
< http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS

Manufacturing software
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
> &k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
> &k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
> &k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
> &k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
> &k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
< http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
> &k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
< http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/> .



________________________________



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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS
Manufacturing
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software
Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
database software Database
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage
software
Pda
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database
software Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
management software Database
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage
<http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


_____




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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



________________________________



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