Using control values within IF field

Similar Threads:

1.replacing values based upon a different field having a word within

I suggest coping the table just in case.

First create a select query and in the 'long description field' criteria use 
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.

"gdwojo" wrote:

> 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??
> 

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

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??

3.Using MAILMERGE fields within HYPERLINK fields for Merge to Email

It appears that MAILMERGE fields within HYPERLINK fields are not updated like 
MAILMERGE fields used elsewhere in a mail merge document as the merge is 
being performed.  Is this correct?

For instance, using the statement below within a document for Merge to Email 
should, in theory, insert the value of the PONumber field for each record of 
the data source into the mailto: hyperlink.  If the HYPERLINK field is 
manually updated using F9, the MERGEFIELD value is updated, the PONumber 
value for the current record is incorporated into the hyperlink and the 
hyperlink functions as expected, however, the MERGEFIELD value is not updated 
when the Merge to Email sequences through each record.

{HYPERLINK "mailto: XXXX@XXXXX.COM ?subject=PO%20{MERGEFIELD 
"PONumber"}%20Already%20Paid" \o "Click here to send an email if you've 
already paid"}

Is there a way to ensure that the MERGEFIELD within the HYPERLINK statement 
is automatically updated when the Merge to Email sequences through the data 
source records?

Thanks, Mark V

4.Form Fields within a Control Text Box?

Is this possible to do? I am trying to copy a particular form, with the 
ability to automatically drag data from a form field into the Control Text 
Box.

I know I can do the same thing without the Control Text Box, but due to me 
trying to make an exact copy of a document, the style of the form field needs 
to be the same as the Control Text Box.

Thanks!

5.using an alphanumeric "word" as a field value in an IF statement

I am attempting to create an IF THEN ELSE statement where the field value I'm 
selecting by is alpha numeric. For example, if I have "06s1" in the compare 
to field, the merged document will always insert the "then" option. If I 
modify it and have "06-s-1" in the compare to field, the funtion works 
properly an inserts the appropriate option - then or else.

Is there some coding I can do so that the function can recognize a "word" 
with both numbers and letters in it?

6. Listing Field Values used in a document

7. Can I compare more than two merge field values using =AND or =

8. How do I save a file using the value entered in a text form field