I have a report with 2 subreports
The first subreport has 3 fields (Expr1, Field1, Field2) Where Expr1
is a Date
I want to highlight the 3 fields if a date is within a range of 2
dates.
I was able to test the expression using [expr1]<>Now() and that worked
if I put it in all 3 fields.
But how do I do that when I am looking at a range of dates?
I do not have a place yet for these 2 dates but was thinking of 2
unbound textboxes on my form.
The second subreport does NOT include the field Expr1 and contains 2
Fields (Field1_Average and Field2_Average). If Field1 is highlighted
in the first subreport I want to highlight Field1_Average also. I am
not able to but them in the same report.
I tried using something like [queryx.expr1]<>Now() just to test it but
it asked for that queryx.expr1 value and I dont want that plus it did
not work when I entered a date.
Any help would be apreciated.