Unanswered: Output/Export a report or query to tabbed Excel spreadsheet
Hi I have a fairly simple staff database, one of the staff fields denotes the area they are based in.
I'd like to output a report and or query for all staff to a single Excel workbook in such a way that the workbook automatically ends up with 6 worksheets, each one labelled as per the 6 possible areas and with only the staff based in that area on that specfic worksheet.
So all staff exported to 1 Excel workbook sorted onto 6 seperate worksheets.
Using Access 2000 and Excel 2002, bit of a novice so simply explained if possible.
Any help much appreciated