S
Sue Compelling
Hi, context is ... my app is a Contact Centre Competency inventory. Each
competency is assessed as Essential or Desired [for each role] and each
individual's performance is assessed as Low or High. I'm developing
reporting to display this data into a quadrant grid.
For each quadrant I've wriiten a statement that draws ALL the competencies
together where the agent was considered Low, then the next quadrant draws on
all the competencies where the agent was considered High etc ...
My problem is I'm trying to have all these fields display sequentially [with
an extra line between each for ease of reading], though if a competency is
not appropriate for this quadrant then the statement is leaving a blank row
for the "empty competency" AND a blank row for readibility [as per my code].
How do I get rid of the blank spaces?
Quadrant Statement is:
=[NegL] & Chr(13) & Chr(10) & Chr(13) & Chr(10) & [NgaL] & Chr(13) & Chr(10)
& Chr(13) & Chr(10) & [ResuL] & Chr(13) & Chr(10) & Chr(13) & Chr(10) &
[ResiL] & Chr(13) & Chr(10) & Chr(13) & Chr(10) & [RespL] & Chr(13) & Chr(10)
& Chr(13) & Chr(10) & [LegL] & Chr(13) & Chr(10) & Chr(13) & Chr(10) & [TTPL]
& Chr(13) & Chr(10) & Chr(13) & Chr(10) & [CasL] & Chr(13) & Chr(10) &
Chr(13) & Chr(10) & [EnfL]
NegL field [and all others] is derived from this type of statement:
=IIf([Neg]="L","Negotiation; achieving suitable outcomes through tactical
engagement","")
Really appreciate any help you can give. I'm relatively "low competent" at
ACCESS.
TIA
Sue Compelling
competency is assessed as Essential or Desired [for each role] and each
individual's performance is assessed as Low or High. I'm developing
reporting to display this data into a quadrant grid.
For each quadrant I've wriiten a statement that draws ALL the competencies
together where the agent was considered Low, then the next quadrant draws on
all the competencies where the agent was considered High etc ...
My problem is I'm trying to have all these fields display sequentially [with
an extra line between each for ease of reading], though if a competency is
not appropriate for this quadrant then the statement is leaving a blank row
for the "empty competency" AND a blank row for readibility [as per my code].
How do I get rid of the blank spaces?
Quadrant Statement is:
=[NegL] & Chr(13) & Chr(10) & Chr(13) & Chr(10) & [NgaL] & Chr(13) & Chr(10)
& Chr(13) & Chr(10) & [ResuL] & Chr(13) & Chr(10) & Chr(13) & Chr(10) &
[ResiL] & Chr(13) & Chr(10) & Chr(13) & Chr(10) & [RespL] & Chr(13) & Chr(10)
& Chr(13) & Chr(10) & [LegL] & Chr(13) & Chr(10) & Chr(13) & Chr(10) & [TTPL]
& Chr(13) & Chr(10) & Chr(13) & Chr(10) & [CasL] & Chr(13) & Chr(10) &
Chr(13) & Chr(10) & [EnfL]
NegL field [and all others] is derived from this type of statement:
=IIf([Neg]="L","Negotiation; achieving suitable outcomes through tactical
engagement","")
Really appreciate any help you can give. I'm relatively "low competent" at
ACCESS.
TIA
Sue Compelling