Absolutely! You put a statement pretty much as you wrote it: in the conditional formatting window you add a formula such as field1 ≠ field2, and then select the formatting you want.
Can you give some more info about what you've tried and how it's not working?
Thanks for your post.
This is what I thought — and tried. However, even when the numbers in these two columns match, they are still treated by the program as not being equal (e.g. "12" in column A and "12" in column B).
I can't figure out what I am doing wrong. Does it matter that I am trying to compare fields in a sub-summary line of a report, and that both of these are summary values themselves? For example, I can get it to work when I compare one of these A or B columns to a C column that is a simple text string — not a number or summary type.
Does it matter that I am trying to compare fields in a sub-summary line of a report
Probably. You must use the GetSummary() function when referring to sub-summary values in a calculation. A better description of what you're trying to accomplish would be useful.
When deciphering the help information on the get summary function, it's helpful to note that the "break" field in the Get Summary function must be the same as the corresponding "sorted by" field in your sub-summary part.
Thank you all. I am successful now when all fields referenced are in the same table, but unsuccessful when they are not. What should I do in that case as a workaround?
Post a description of the relationship between your tables and the way you need your summary field to calculate. It may turn out that using an aggregate function such as Sum, count, average, or .... can be used in place of your summary field. (Aggregate functions can be looked up in help for a comprehensive list and their definitions.)
My report includes multi-field money summaries (totals and averages), sub-summarized: 1) by year; 2) by several "pay grade" levels. This second sub-summary BreakField is not resident on the table, and I think needs to remain there for its relationship to numerous other tables in the database.
I discovered by trial that if I make the field native to the table in question the conditional formatting works fine.
Can I/should I duplicate this "pay grade" field somehow to make this all work?
Have you checked out the Aggregate function option?
It's usually best to avoid putting the same data in two different tables like this. I don't think that will be necessary, but can't tell from your description.
If you want to pursue this futher, list out the fields used to summarize your data, the break field and how the tables are related.
I have sSummary, which computes a subtotal of Datafield. Fieldx serves as the break field.
These fields are in the following tables....
Their relationship looks like:
Table1::Key = Table2key
and so forth.
The GetSummary() function won't work if breakField is a related field.
Either add a calculation field = Related::BreakField, or use the local foreign key field as the breakField.