Displaying results of a query in Word

[kathyc20]

I have a word document which I need to add the results of a query.

This queries the database for a specific customer and displays the product(s) they have purchased. They may be as many as 10 records.

This is to be formatted in tables, as shown below:

I can't seem to get this working properly.

(1) I want the cust_name and cont_name to display only once.

(2) Table area below: I am able to display the fields that are required, but the format seems to be whatever is available in Word.

Can someone please help me with this.

___________________________________________________________

Customer Name: cust_name
Contact Name: cont_name


Product License Key Cust # Serial #
______________________________________________________
Prod_Name Lic_Key Cust_Num Serial_Num

 

[SkipVought]

Hi,

I want the cust_name and cont_name to display only once.

Then, you need TWO queries; one for the summary or header data and one for the detail data.

If I were doing it, I'd do the query in Excel and link the sheet to Word. In fact, I might do the entire thing in Excel -- what else is in Word that can't be done in Excel?

Skip,
[sub]
[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen![/sub]