Lallo

It's an eternal question... I would err toward access and you can always use
Excel to analyse the reports produced. You are limited to 65k rows
(records) currently and that may mean changes too regularly

Access is a database tool...you could enter it here and easily bring it into
an excel pivot table to report via DataPivot table report or chart and then
use external data as your source and navigate to your Access
file/Table/Query

Personal preference, but start in the correct tool and if it is overkill,
move to Excel solely

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Lallo" wrote in message
...
I've been trying to decide if Microsoft Access would be better than Excel
for
storing large amounts of weekly, quarterly, and yearly sales reports for
my
restaurant business. I'm not sure if Access is the best fit ... any
advice?

Thanks.