I have recently run a query which tells me the name and ref no of units that have applied for a grant in the period leading up to 31/12/2006. However I need to write to the contact person at each unit to ask them for feedback, and i need to run a query which gives me the address for the units that I have already obtained on my first query, so I can then run a mailmerge. is there a simple way of doing this?
Thanks.

Hi Susan

If I have this correct, you have a query that shows the Ref No and the Name of only the Units that applied for grants in the given period (e.g. Grants_2006).

To create a query to obtain their addresses do the following:

1. Create a new query (e.g. Grant_Addresses_2006)

2. In the query combine the Grants_2006 query with the table (e.g. Unit_Details) that holds the Unit's address details and pull down the following fields:

From the Grants_2006 query – The Ref No field

From the Unit_Details table – the Unit name and all relevant address fields

Make sure the Join type is 1.

When you nrun the query it will give you only the addresses of the relevant units.

Hope this helps

Carlos