replacing values based upon a different field having a word within a description

[gdwojo]

I need to find all records in the database and then make a change in a
different field of that record based on whether the text exists in the field.


I have a pricing database where I have a discounting scheme that I apply. I
take the list price, apply a discount, and then determine if the price is a
minimum percentage above my cost. If the discount makes the price less than
the minimum profit, then I make the customer price the minimum profit,
otherwise I apply the discount that I have determined. However, on one
specific group of items, I apply a different discounting scheme. For every
one of these specific items (call them widgets) the word widget appears in a
long description field. For all widgets, if I want to change the
percentage of discount so I need to find all widgets and then replace the
discount percentage.

If all items are discounted at 20%, and I need widgets to discount at 30%
then I would like to change the value of my discount field for that record
from .20 to .30. Anybody have any ideas?

Is there any way to do this. - If not, how do I just put a record that I
can search on that tells me that the word widget shows up in the description
field??

 

[Guest]

I suggest coping the table just in case.

First create a select query and in the 'long description field' criteria use
--
Like "*widgets*"

Run the query and review the data to make sure you are not pulling records
that you do not want to change. If there are unwanted records then devise
additional criteria to eliminate them.

Then change query type by clicking on the icon bar the two pages with down
arrow on the right and select Update Query. Enter the new information in the
design grid. and run the query.

 

[Guest]

I have a form in access to data collection

Taxbox 1 contain
Name : First Name Last Name
I want to saprate First Name & Last Name Like This
First Name : First Name
Last Name : Last Name
at lost focus event of taxtbox 1