If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Export to Excel worksheet
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. |
Thread Tools | |
Display Modes | |
|
|