Conditional Format Expression Problem

[Jeff C]

My report is based on a totals query (query1). I have a second query
(query2) with some but not all of the items from (query1). I am failing at
attempts to write an expression for the conditional format. Query1.Model =
Query2.Model. When I run the report I want all the items which are in both
query1 and query 2 to print in bold. Thanks for your help.

 

[Marshall Barton]

My report is based on a totals query (query1). I have a second query
(query2) with some but not all of the items from (query1). I am failing at
attempts to write an expression for the conditional format. Query1.Model =
Query2.Model. When I run the report I want all the items which are in both
query1 and query 2 to print in bold. Thanks for your help.

Create a third query based on both of your existing queries.
Drag the Model field from one query to the Model field in
the other query. Double click on the line joining the two
queries and set the Join Type to include all records from
the query1 and any matching records from query2. Set the
alias name of the two fields to Model1 and Model2.

You can now use Conditional Formatting (Format menu) on the
detail section's text boxes. Set the Expression Is box to
[Model2] Is Not Null

 

[Jeff C]

Thanks Marsh

My report is based on a totals query (query1). I have a second query
(query2) with some but not all of the items from (query1). I am failing at
attempts to write an expression for the conditional format. Query1.Model =
Query2.Model. When I run the report I want all the items which are in both
query1 and query 2 to print in bold. Thanks for your help.

Create a third query based on both of your existing queries.
Drag the Model field from one query to the Model field in
the other query. Double click on the line joining the two
queries and set the Join Type to include all records from
the query1 and any matching records from query2. Set the
alias name of the two fields to Model1 and Model2.

You can now use Conditional Formatting (Format menu) on the
detail section's text boxes. Set the Expression Is box to
[Model2] Is Not Null