G
Guest
How can I include two records from a query or table in one text box in a
report? For example, I have a table with names, three fields per name: Prefix
(Mr., Mrs., etc.), First name, Last name. On the report, I would like to show
"Mr. & Mrs. Joe & Jane Smith". So far I have got as far as "Mr. Joe Smith",
because he is one record (entry) in the query. How do I include his wife, a
second entry in the query, with him in the same text box? I would appreciate
help!
Thanks
report? For example, I have a table with names, three fields per name: Prefix
(Mr., Mrs., etc.), First name, Last name. On the report, I would like to show
"Mr. & Mrs. Joe & Jane Smith". So far I have got as far as "Mr. Joe Smith",
because he is one record (entry) in the query. How do I include his wife, a
second entry in the query, with him in the same text box? I would appreciate
help!
Thanks