query in access

[PaulB]

Hello

I need to export a file from access this I can do. But the info that needs
putting in there is from a query there needs to be a header line and a detail
line e.g

All the detail is coming from an OBDC link to MS SQL

the header line will have e.g cust no,date,orderno,
H,el22,120209

the detail line will have e.g. prod code, description,qty
D,1234,test,2

and the out put file will need to look some thing like this
H,el22,120209
D,1234,test,2
D,1234,test,2
H,el99,120209
D,1234,test,2
D,1234,test,2

I can pull the info from 1 or 2 tables e.g. one for customer info and one
for the order info when I run it I get the in for like this
H,el22,120209,D,1234,test,2
H,el22,120209,D,1234,test,2
H,el99,120209,D,1234,test,2
H,el99,120209,D,1234,test,2

Thanks in Advance. I would be glad from any help you can provide.

Paul