"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Can you give us a little more info on why you think you need to do this?

I can't immediately see any reason to need this in Access. Where Excel sheets are pretty much open-ended rows and columns of cells with no set definition necessary, Access is a structured database where a row is always going to be one record of data and each record contains its actual data fields in columns.

Thus my reason for asking for some background info..

exp vgAuthor Commented: 2015-08-02

I am working on creating an automated system for people other than myself, so the less steps they have to do the better.

If I can create all of these queries in Access itself, and export it to excel in as near to final format, the easier it will be on them.