C
ChuckW
Hi,
I have a field that has percentage values as part of
text. For instance, it will John Smith 10% Commission or
Joe Jones 15% Commission. What I need to do is to
isolate the percentage and use this as a calculated
value. I would then multiply a sale value from another
field by .1 for John Smith and .15 for Joe Jones. Is
there a way to run a query or queries that go from Joe
Jones 15% Commission to .15 and John Smith 10% Commission
to .1?
Thanks,
Chuck
I have a field that has percentage values as part of
text. For instance, it will John Smith 10% Commission or
Joe Jones 15% Commission. What I need to do is to
isolate the percentage and use this as a calculated
value. I would then multiply a sale value from another
field by .1 for John Smith and .15 for Joe Jones. Is
there a way to run a query or queries that go from Joe
Jones 15% Commission to .15 and John Smith 10% Commission
to .1?
Thanks,
Chuck