Access Export to Excel worksheet

K

Ken

I have two tables that I wish to export to a single worksheet in Excel.

The first table is called Travels which includes Trip Number, Travellers
name, total allowance, ticket cost and total costs. The second file is called
destination which includes trip number, destination name, leave date and
return date. These files are joined by Trip number.

It is possible to have multiple destination records to one Travels record.

My problem is when there is mutiply destination for one trip, in the export
routine the allowance, ticket cost and total cost are repeated.

How can I show only the values on one line (record) and the other records
showing blank?

Thanks, in advance, for your assistance.
 
Top