Conditional Format based on Query criteria

[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?

 

[Ken Snell \(MVP\)]

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.

 

[cna48]

Thanks Ken for helping connect the dots. It worked great. Sometimes it's
the simple answers that help the most.

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>

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?