Any record in the form cannot be both Level0 and StatusComplete Scenario: A record in the form has been (legally) set to Level3 and StatusComplete.

2) fldStatus is a limited value-list (Combo) with 3 choices Unassigned, In-Progress, Complete.

When used in this way, the value of COMPARE is limited only by your imagination. I want to compare two multivalued fields that i have in a table. A form has two fields: 1) fldLevel it’s an Option Group with 4 choices 1, 2, 3 and 0. The matching numbers will be put next to the first column, as illustrated here: A. The duplicate numbers are displayed in column B. For instance, you might use COMPARE in conjunction with the IF field to specify conditional text for your document. To do this, select File > Options > Customize Ribbon, and then select the Developer tab in the customization box on the right-side. Given Field1 and Field2 (assume that they should contain the same code, but come from different sources - dont worry about why), can I run a filter that would compare Field1 against. Where COMPARE comes in handiest is when you use it as an argument for one of the other comparison fields. Is there a way to use a table filter to compare two fields in the same table against each other. If it is not, then COMPARE returns a value of 0 (False).Īs you might imagine, returning a zero or a one, by itself, may not be that valuable of a feature. This section describes several specialized constructs for making multiple comparisons between groups of values. If the bookmark (MyBook) is equal to TestText, then the COMPARE field returns a value of 1 (True). If your bookmark name is MyBook, the following COMPARE field will do the trick: Please tell me whether it is possible in Query or whether i have to go for basic report Regards. All you need to do is provide the two values (along with the comparison operator), and COMPARE will return either a 1 if the comparison is true or a 0 if it is false.įor example, let's say you wanted to compare the contents of a bookmark to see if it was equal to a specific value. I want to display only those rows where Qty1 > Qty2. work within the jquery form validation plugin because I. I know I could write my own submit handler to do this, but Id like to. lists and that the value in the first list is not the value in the. I want to make sure that something is checked in both. The entire purpose of the COMPARE field is to do exactly what it says-compare values. I have a form with two radio button lists. Most people don't use this field that much because it can be confusing to do so. We check that the username field does not have the word admin in this example.One of the fields that Word makes available for automating your documents is the COMPARE field. You can use UM action hooks to apply custom validations and rules for any fields and stop forms from being submitted until the conditions are met.

Forms to go compare two fields