D
Debbie S.
I have created a query on which a report is based that shows authors of
articles. In my data entry form I can enter two author's names for any one
article, however, if I want the report (and thus the query) to show BOTH
authors' names in the event that there are two (or three or more), how would
I program the query to do that? Right now I have the query set to ask for the
author's last name, first name, so you get that same prompt for the report.
Problem is I can only enter one name with that setup. I'd appreciate any
thoughts or suggestions.
Thank you.
articles. In my data entry form I can enter two author's names for any one
article, however, if I want the report (and thus the query) to show BOTH
authors' names in the event that there are two (or three or more), how would
I program the query to do that? Right now I have the query set to ask for the
author's last name, first name, so you get that same prompt for the report.
Problem is I can only enter one name with that setup. I'd appreciate any
thoughts or suggestions.
Thank you.