Conditional Format based on Query criteria

  • Thread starter Thread starter cna48
  • Start date Start date
C

cna48

I have a report that I would like to use a conditional format.

I would like to format that based on a criteria in the query.

Example:

I have a [date field] in the query that has ">[Enter The Begining Date]" as
the criteria.

I want the criteria to be
Expression Is _____ [date field2]<#[Enter The Begining Date]"


In short, how do I use the criteria for one field as the conditional format
for another field?
 
Add another calculated field to your query and use it to contain the
parameter value that is entered:

ParameterDate: [Enter The Begining Date]

Then use the ParameterDate field in your report's Conditional Formatting
expression.
 
Thanks Ken for helping connect the dots. It worked great. Sometimes it's
the simple answers that help the most.

Ken Snell (MVP) said:
Add another calculated field to your query and use it to contain the
parameter value that is entered:

ParameterDate: [Enter The Begining Date]

Then use the ParameterDate field in your report's Conditional Formatting
expression.

--

Ken Snell
<MS ACCESS MVP>


cna48 said:
I have a report that I would like to use a conditional format.

I would like to format that based on a criteria in the query.

Example:

I have a [date field] in the query that has ">[Enter The Begining Date]"
as
the criteria.

I want the criteria to be
Expression Is _____ [date field2]<#[Enter The Begining Date]"


In short, how do I use the criteria for one field as the conditional
format
for another field?
Click to expand...
Click to expand...
 
Back
Top