If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

is this a one off requirement or is it going to be a regular occurance?

if its a one off I'd open Excel and run a series of queries to retrieve the data I need.
if your SQL & office integration skills are good enough you could probably have a single Excel worksheet and extract the data as required.

if its a regular occurance then I'd write some VBA in Access to 'push' the data into an Excel spreadhseet. there some good stuff int eh code bank for talking to Excel from Access.. I think its by Pootleflump and others