Group Header Info

C

Cheswyck

In a report I am using department number as a control
group. However,I want to print the department NAME
for each group but my input only has the dept number. In
the dept header area I tried using a case instruction
to choose which dept name to use, there are only 3, but I
got a message saying it can't find dept number. If I just
put a control to display the dept number it displays. How
do I get the dept name to print in the group header when I
only have the dept code?
 
B

Bill Crawford

Is your input in the form of a popup window, asking for the department
number? And does the report's underlying query have the department name
field? If 'true' for both instances, than add the[DeptName] field to the
report in the dept header section.

ta da. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculated control: Grand Total 8
subtotal of total of some of the groups 6
Report sorting 1
Top values report 5
Text in footer 1
Special Grouping in a Report 6
Logical Test for a value in a named list? 10
combo box with parent table 2

Top