Export Query to Excel

[TheVedek]

I have two queries

query 1.

ProjID
TaskID
Money
Money2
ProjContact

querie 2.
TaskID
TaskName
Taskperson

I have one to many from query 1 TaskID to query 2 TaskID

I want the excel output to look like the followng.

ProjID TaskID Task Name TaskPerson Money Money2 ProjContact
1 100
100 pcontact1
1 3 task1 taskperson1

1 4 task2 taskperson2
2 600
500 pcontact2
2 5 task3 taskperson3

Notice the project has it's own line and tasks are under it. There is no
money values for task.



Thanks.

 

[Klatuu]

You wont be able to do that with a query. You will either have to have the
Project data on each line with the Task data (which is how a normal
spreadsheet usually is) or use automation to create the spreadsheet.

 

[TheVedek]

The output format got mangled.

I would like it look like this:

ProjID TaskID TaskName TaskPerson Money Money2 ProjContact
1 100 100 Pcontact1
1 3 Task1 Tcontact
1 4 Task2 Tcontact1
2 600 500 Pcontact2
2 6 Task3 Tcontact1