T
tgsms
I am trying to create a name label for a member file containing both
individuals and companies. An affiliation field tells me whether the record
is for an individual or company. If the record is for a person I want to
format the label using the fields prefix, firstname, lastname, ect.. If the
record is for a company I want to display only the company name stored in
what doubles as the Person's employment field.
Does Access have a way to create this sort of conditionally filled field?
individuals and companies. An affiliation field tells me whether the record
is for an individual or company. If the record is for a person I want to
format the label using the fields prefix, firstname, lastname, ect.. If the
record is for a company I want to display only the company name stored in
what doubles as the Person's employment field.
Does Access have a way to create this sort of conditionally filled field?