Can I Make My Own Reports Look Like Excel?

[Carl Jarvis]

I am looking to automate the monthly reporting side of my job, and would
like to use Access to simplft the process.

I have all of my raw data in my table which will be added to on a monthly
basis, I have my queries written, but I cannot for the life of me get a
report format anything like Excel.

I would love to be able to control the 'page view' of the report and have 14
colums (Title, Jan-Dec & Total) with the relevant row headers down the left.
Surely this can be done (maybe with the formulas in the report itself?)

I would appreciate any help / advice given.

Many thanks,

Carl.

 

[Duane Hookom]

It would really help to know a little about your data. I think you could use
a report based on a crosstab query. You might want to look at the crosstab
samples at http://www.invisibleinc.com/divFiles.cfm?divDivID=4. Maybe the
calendar reports might also interest you.

 

[Carl Jarvis]

The CrossTab report looks exactly like what I am looking for, neat, tidy all
on one page etc - now I know it can be done I need to figure out how to get
my hands dirty!

Thanks for your help.

Carl.