including two records in one text box

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
 
G

Guest

Thanks, I'll have a look at that. I also have a list of who is married. For
numbering reasons, in the query, each person is entered individually. I was
just trying to figure out how to get two entries int the same text box. It
wouldn't necessarily have to be a husband and wife, it could just two people
who are in the same categories through the database.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top