Header and Detail Query

[jagloha]

Hi, can someone please help me out. I have 2 queries 1 header level and 1 detail level.
In MS Access query I would like to show one header line and multiple order lines.
e.g.
Header
Line 1
Line 2
Line 3
Line 4
Header
Line 1
Line 2
Line 3
Line 4
Header
Line 1
Line 2
Line 3
And so on.
Many thanks in advance

 

[Ziggy1]

That's what reports are for, you need to join the header/detail as one query and use it as the control source for a report. The report will use grouping levels to control the out put as you describe it.

the 2 tables are joined in the query by their related field ID... "order ID" Your output will show the header side repeat for every detail record..per ID This will work out the way you want in a Report.

I don't know your level of experience so tell me what you need me to explain further.

 

[jagloha]

That's what reports are for, you need to join the header/detail as one query and use it as the control source for a report. The report will use grouping levels to control the out put as you describe it.

the 2 tables are joined in the query by their related field ID... "order ID" Your output will show the header side repeat for every detail record..per ID This will work out the way you want in a Report.

I don't know your level of experience so tell me what you need me to explain further.

I need it to export out as a CSV file my level of experince is very low. I am also trying to do this in access