Analyze Access data

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

I have a query in an Access database. I want to use the Tools>Analyze With
Excel option to create a spreadsheet using the data in the query. One of the
fields in the Access query is Order Number. I would like to create a
"header" in the spreadsheet which will contain the value in the Order Number
field. I only want this information to appear once on the spreadsheet. How
can I do this?

Ivor
 
If I understand you correctly, you might try exporting the
query output via a report. Group on Order Number with the
Group Header showing and the Order Number field in the
group header. Excel will pick up the header as a distinct
row and the rest of the detail will fall into separate
cells in the next rows. This should work for multiple
Order Numbers as well.
HTH
 
Back
Top