T
tvh
I placed a concatenation in a query (Name(s): [tblwodLeadTechnician] &"/"&
[tblwodAssistant] &"/"& [tblwod2ndAssistant]) so that the last name of the
employees are viewed in a single cell, but I have two problems:
1.) How do I right the equation so that the "/" are not visible if there is
not an Assistant or 2nd Assistant?
also,
2.) I have a combo box in the form where I can select an employee's last
name. However, the value that is returned in the report is the Primary Key
value, ie; "001" instead of "Smith".
I know that using a control wizard while building the report would help, but
for some reason the wizard is not currently enabled (and, yes, the "control
wizard" buttton in the toolbox is depressed).
Thanks
[tblwodAssistant] &"/"& [tblwod2ndAssistant]) so that the last name of the
employees are viewed in a single cell, but I have two problems:
1.) How do I right the equation so that the "/" are not visible if there is
not an Assistant or 2nd Assistant?
also,
2.) I have a combo box in the form where I can select an employee's last
name. However, the value that is returned in the report is the Primary Key
value, ie; "001" instead of "Smith".
I know that using a control wizard while building the report would help, but
for some reason the wizard is not currently enabled (and, yes, the "control
wizard" buttton in the toolbox is depressed).
Thanks