Report – Conditional Formatting

[AFSSkier]

I have a query that compares field changes between an old and new tables. In
a report, I would like to hi-light only the data that changed in a given
field.

With conditional formatting, I've tried the following expressions without
success.
• Field Value Is: not equal to [OLD TABLE]![FIELD NAME]
• Expression Is: [OLD TABLE]![FIELD NAME] <> [NEW TABLE]![FIELD NAME]

 

[Ofer Cohen]

Try

not equal to [FIELD NAME]

Without the table name

 

[AFSSkier]

not equal to [FIELD NAME] doesn't work.

The field names are the same in each table. Some of the data is different.
The [OLD TABLE] is a copy of last months table. The report shows and changes
made.
--
Thanks, Kevin

Try

not equal to [FIELD NAME]

Without the table name
--
Good Luck
BS"D

I have a query that compares field changes between an old and new tables. In
a report, I would like to hi-light only the data that changed in a given
field.

With conditional formatting, I've tried the following expressions without
success.
• Field Value Is: not equal to [OLD TABLE]![FIELD NAME]
• Expression Is: [OLD TABLE]![FIELD NAME] <> [NEW TABLE]![FIELD NAME]

 

[Ofer Cohen]

Try and give it the name of the text box within the report instead of the
name of the field in the table

--
Good Luck
BS"D

not equal to [FIELD NAME] doesn't work.

The field names are the same in each table. Some of the data is different.
The [OLD TABLE] is a copy of last months table. The report shows and changes
made.
--
Thanks, Kevin

Try

not equal to [FIELD NAME]

Without the table name
--
Good Luck
BS"D

I have a query that compares field changes between an old and new tables. In
a report, I would like to hi-light only the data that changed in a given
field.

With conditional formatting, I've tried the following expressions without
success.
• Field Value Is: not equal to [OLD TABLE]![FIELD NAME]
• Expression Is: [OLD TABLE]![FIELD NAME] <> [NEW TABLE]![FIELD NAME]

 

[AFSSkier]

The report only has text boxes from the [NEW TABLE]. I want to hi-light only
the changes to the field data.
--
Thanks, Kevin

Try and give it the name of the text box within the report instead of the
name of the field in the table

--
Good Luck
BS"D

not equal to [FIELD NAME] doesn't work.

The field names are the same in each table. Some of the data is different.
The [OLD TABLE] is a copy of last months table. The report shows and changes
made.
--
Thanks, Kevin

Try

not equal to [FIELD NAME]

Without the table name
--
Good Luck
BS"D


:

I have a query that compares field changes between an old and new tables. In
a report, I would like to hi-light only the data that changed in a given
field.

With conditional formatting, I've tried the following expressions without
success.
• Field Value Is: not equal to [OLD TABLE]![FIELD NAME]
• Expression Is: [OLD TABLE]![FIELD NAME] <> [NEW TABLE]![FIELD NAME]

 

[AFSSkier]

From your suggestions, I was able get if to work. I had to change the field
names in my query. The [OLD TABLE] DESCRIPTION to DESC, etc.

The following two conditional formatting works:
• Field Value Is: not equal to [OLD TABLE]![DESC]
• Expression Is: [OLD TABLE]![DESC] <> [NEW TABLE]![DESCRIPTION]
--
Thanks, Kevin

Try and give it the name of the text box within the report instead of the
name of the field in the table

--
Good Luck
BS"D

not equal to [FIELD NAME] doesn't work.

The field names are the same in each table. Some of the data is different.
The [OLD TABLE] is a copy of last months table. The report shows and changes
made.
--
Thanks, Kevin

Try

not equal to [FIELD NAME]

Without the table name
--
Good Luck
BS"D


:

I have a query that compares field changes between an old and new tables. In
a report, I would like to hi-light only the data that changed in a given
field.

With conditional formatting, I've tried the following expressions without
success.
• Field Value Is: not equal to [OLD TABLE]![FIELD NAME]
• Expression Is: [OLD TABLE]![FIELD NAME] <> [NEW TABLE]![FIELD NAME]