I'm stuck on developing a system to "flag" when 2 criteria are met

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I have a query based 2 tables:
tblClient - using 3 fields [LN] (last name), [FN] (first name) and [DOB]
(date of birth)
tblSession - using 1 field, [SessionDate]

I've got an additional column in the design grid which calculates each
client's age from their DOB.

I "grouped by" a count of SessionDate's.

I want to develop a report which will be used to "flag" (via conditional
formatting) when either of these 2 conditions are met... and both of the
conditions involve working with more than one field:
If client is less than 18 years of age, I want to be alerted once the client
has had 16 sessions.
If client is 18 years of age or older, I want to be alerted once the client
has had 4 sessions.

I'm stuck. Do I do something with conditional formatting in this report to
achieve my goal, or do I need to do something else in the query on which the
report is based first?

Thanks.
 
Assuming you have both ClientAge & SessionCount, set ConditionalFormat to
Expression Is and make two conditions:

Condition1: [ClientAge] < 18 And [SessionCount] >=16
Condition2: [ClientAge] >+ 18 And [SessionCount] >=4

Or even use two sections in parentheses in one condition with OR in between,
like this:

(ClientAge said:
=4)
Click to expand...


Sue said:
I have a query based 2 tables:
tblClient - using 3 fields [LN] (last name), [FN] (first name) and [DOB]
(date of birth)
tblSession - using 1 field, [SessionDate]

I've got an additional column in the design grid which calculates each
client's age from their DOB.

I "grouped by" a count of SessionDate's.

I want to develop a report which will be used to "flag" (via conditional
formatting) when either of these 2 conditions are met... and both of the
conditions involve working with more than one field:
If client is less than 18 years of age, I want to be alerted once the client
has had 16 sessions.
If client is 18 years of age or older, I want to be alerted once the client
has had 4 sessions.

I'm stuck. Do I do something with conditional formatting in this report to
achieve my goal, or do I need to do something else in the query on which the
report is based first?

Thanks.
Click to expand...
 
That did the trick - thank you so much! My fields were [Age] and
[CountOfSessionDate], and I used this expression:

Condition 1: ([Age]<18 And [CountOfSessionDate]>=16) Or ([Age]>+18 And
[CountOfSessionDate])

Perfecto!
--
Thanks for your time!


Brian said:
Assuming you have both ClientAge & SessionCount, set ConditionalFormat to
Expression Is and make two conditions:

Condition1: [ClientAge] < 18 And [SessionCount] >=16
Condition2: [ClientAge] >+ 18 And [SessionCount] >=4

Or even use two sections in parentheses in one condition with OR in between,
like this:

(ClientAge said:
=4)
Click to expand...


Sue said:
I have a query based 2 tables:
tblClient - using 3 fields [LN] (last name), [FN] (first name) and [DOB]
(date of birth)
tblSession - using 1 field, [SessionDate]

I've got an additional column in the design grid which calculates each
client's age from their DOB.

I "grouped by" a count of SessionDate's.

I want to develop a report which will be used to "flag" (via conditional
formatting) when either of these 2 conditions are met... and both of the
conditions involve working with more than one field:
If client is less than 18 years of age, I want to be alerted once the client
has had 16 sessions.
If client is 18 years of age or older, I want to be alerted once the client
has had 4 sessions.

I'm stuck. Do I do something with conditional formatting in this report to
achieve my goal, or do I need to do something else in the query on which the
report is based first?

Thanks.
Click to expand...
Click to expand...
 
Back
Top