Text appearing only under certain headings

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

I have a report that I would like to look like the
following:

Division Name Ext

ADMINISTRATION
Joe Schmoe 4311
Mary Schmoe 2926
SECURITY
John Smith 1234
"After Hours Call ##" Mary Smith 4567

Each name has an assigned Division. Tried to force the
words and number under Name with Security as Division,
but then it appears on another report that I don't want
those words on.
Is there some sort of "If the Division name is Security
than show Text box, if not than don't" statement???

Kelly
 
Unless I am missing something I see only a standard report
grouped by Division and sorted by FirstName
You would put the textbox for the Division in the
groupheader band and the textboxes for the names and
extension are in the detail band of the report.
Hope this helps.
Fons
 
The part you are missing is that ONLY under the Section
of Security, I need a statement that says "After 5pm call
this certain number".

Kelly
 
I must have missed that.
Just as you suggest, for that memo text box you can put in
the datasource: =IIF([Division] = "Security", "After 5pm
call this certain number","")
Hope this helps.
Fons
 
-----Original Message-----
I must have missed that.
Just as you suggest, for that memo text box you can put in
the datasource: =IIF([Division] = "Security", "After 5pm
call this certain number","")
Hope this helps.
Fons
-----Original Message-----
The part you are missing is that ONLY under the Section
of Security, I need a statement that says "After 5pm call
this certain number".

Kelly
.
Click to expand...
.
Click to expand...
 
I really really want to thank you!! I tried I don't know
how many times to right the if statement, and kept
getting Parameter pop ups and expression errors
statements, but I copy and pasted you If statement and it
worked like a dream!!!!

Now the men dressed in white with the really long armed
jackets won't have to come take me away......I WAS
DRIVING ME NUTSO!!!

Thank you,

Kelly
-----Original Message-----
I must have missed that.
Just as you suggest, for that memo text box you can put in
the datasource: =IIF([Division] = "Security", "After 5pm
call this certain number","")
Hope this helps.
Fons
-----Original Message-----
The part you are missing is that ONLY under the Section
of Security, I need a statement that says "After 5pm call
this certain number".

Kelly
.
Click to expand...
.
Click to expand...
 
You're welcome.
Fons
-----Original Message-----
I really really want to thank you!! I tried I don't know
how many times to right the if statement, and kept
getting Parameter pop ups and expression errors
statements, but I copy and pasted you If statement and it
worked like a dream!!!!

Now the men dressed in white with the really long armed
jackets won't have to come take me away......I WAS
DRIVING ME NUTSO!!!

Thank you,

Kelly
-----Original Message-----
I must have missed that.
Just as you suggest, for that memo text box you can put in
the datasource: =IIF([Division] = "Security", "After 5pm
call this certain number","")
Hope this helps.
Fons
-----Original Message-----
The part you are missing is that ONLY under the Section
of Security, I need a statement that says "After 5pm call
this certain number".

Kelly
-----Original Message-----
Unless I am missing something I see only a standard
report
grouped by Division and sorted by FirstName
You would put the textbox for the Division in the
groupheader band and the textboxes for the names and
extension are in the detail band of the report.
Hope this helps.
Fons
-----Original Message-----
I have a report that I would like to look like the
following:

Division Name Ext

ADMINISTRATION
Joe Schmoe 4311
Mary Schmoe 2926
SECURITY
John Smith 1234
"After Hours Call ##" Mary Smith 4567

Each name has an assigned Division. Tried to force the
words and number under Name with Security as Division,
but then it appears on another report that I don't want
those words on.
Is there some sort of "If the Division name is Security
than show Text box, if not than don't" statement???

Kelly
.

.

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