Query: Two Tables - Need one result for qry rs 1

[Dragunsfyre]

I have an Access 2000 database with two critical tables, tblClients and tblChildren. I am trying to generate a query which will produce a one record recordset for use with Word 2000 Mail Merge documents. The desired recordset would include the needed client information and the names and DOBs of each child. Each client in tblClients only has one record, each child in tblChild only has one record and they are linked by the primary key field, FileNumber. My problem is that some clients have no children, others have many.

How do I generate a query so that, if I enter FileNumber as my query parameter, I only get one record in my recordset(as opposed to the number of records equal to the number of children)? Also, I need to be able to count the children because my Word document needs to know how many there are.

 

[PHV]

2 FAQs dealing with this issue in this forum.
Have you even searched ?

http://www.tek-tips.com/faqs.cfm?fid=4233

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