how to have 2 different records in one report

[stephanr]

I want to create an envelope which has the recipients and the senders address on it. The recipients address is the record itself in the database and the senders address is a field with the record number in the same table.

Basically I need a report with two different records in it which are in the same table.

I am new to VB and don’t want to reinvent the wheel…

 

[PHV]

Use a query with a self join as RecordSource.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[stephanr]

You mean I can just write and SQL command that takes care of it???
Do you have an example?
Like I said I am new in Access.

 

[PHV]

A starting point:
SELECT Sender.Name, Sender.Address, Recipient.Name, Recipient.Address
FROM yourTable AS Recipient INNER JOIN yourTable AS Sender
ON Recipient.SenderKey = Sender.PrimaryKey

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[stephanr]

Thanks that is not as hard as I thought it would be.
Now I still have the problem of actually getting the content in my word document.
I figured out how to create a word document and how to change/add content from VBA.
How do I access the database and run the SQL statement from VB? Is there an easy way to do it with ODBC?