I'm still a little new to Access, and I'm sure I'm missing some key
piece of information, but I can boil it all down to this:
I have an Employee table. Two of the fields are
Empl_First
Empl_Last
I have a calculated field, which is part of the record source to a
report defined as:
LNF: [Empl_Last]&", "&[Empl_First]
One of our employees is a CNA (Certified Nurse Assistant). I want to
change the LFN to include that, so I added a field Empl_Title to the
employe table, and chenged the recored source to the report:
LNF: [Empl_Last]&", "&[Empl_First]&" "&[Empl_Title]
Problem is that LNF only works for the one record that contains
something (not a null) in the Empl_Title field. What I really want is
for it to treat Empl_Title as a blank so that every record will print,
even if the employee doesn't have a title.
DO CALCULATED FIELDS ONLY WORK IF EVERY COMPONENT OF THE EXPRESSION IS
NOT A NULL?
This example probably reveals a larger misunderstanding as to how
Access works, but it's a start. Any help is greatly appreciated.