Access combination query

Here's my situation

I have 2 MS Access 2003 tables in order table and an order detail table

here is a sample layout for the order table

order_id     order_date
1234           20080710
2345           20080711


here is a sample layout for the order_detail  table

order_id     part_num
1234           ABC123
1234           XYZ123
2345           ABC123




I have been asked to create a csv file that will take order id records, followed by corresponding
order detail.  (Via an ms access form)

Using the sample data it would look like the following
1234,20080710,ABC123,XYZ123
2345,20080711,ABC123

Is there a way I can write a query that would return the data in the above format?

I was thinking I could create a recordset from the query and then write the field values to a file

I did something similiarusing sql server using a user defined function way back when but not sure if access has the equivalent.Start Free Trial